I have 4:23 (hours) and $2.15 (rate). How do I input into Excel to get the wage. Thanks.

---

Richard Answers:

4:23 is 4 hours and 23 minutes which Excel stores internally as a FRACTION of a whole day. So, if you have 4:23 in cell A1, then in cell B1 you can put:

=A1*24

This will show you 9:12, but don't worry about that, change the FORMAT of the cell to a NUMBER and you'll see that it comes out to 4.28 which is the number of HOURS that 4h23m represents.

Now, in cell C3 you can put your rate ($2.15) and then it's simple multiplication in D1:

=B1*C1

Easy enough? The key here is just realizing that a DAY is equal to 24 hours.