MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Convert time

Posted by Paul on April 28, 2001 3:26 PM

I am working on a time sheet and my hours are 19:00 to about 2:30. I need a formula to convert the hours worked with the rate of pay. Any ideas?

Posted by Mark W. on April 28, 2001 3:45 PM

Use ="19:00"*24*10.5 to convert 19 hours @ $10.50/hr to

Posted by Mark W. on April 28, 2001 3:47 PM

Of course, you can substitute a cell reference
containing a time value for "19:00" in the
formula below.

Posted by Paul on April 28, 2001 4:35 PM

Have tried but does not seem to work.... Any ideas? If I exchange the "19:00" to a cell value like =C2*24*10.5 (c2 is 07:00) I get 18:00. Any ideas.....?

Posted by Mark W. on April 28, 2001 4:55 PM

Aah, one thing about Excel... when you enter a formula
containing a reference to a cell that is Date or
Time formatted it applies the same format to the cell
containing the formula. Just change the format of
the cell containing your formula to an appropriate
Currency format using the Format | Cells... menu

Posted by Dave Hawley on April 28, 2001 7:15 PM

Hi paul

I just sent this:
Hi Paul

If your total hours are in cell D3 and the pay rate in cell E3, then you would use:
and format the cell as currency.

But I forgot to mention that it is good practice to include parenthesis in the appropriate place when doing calculations as it makes the formula easier to read. It also will get you into the habit of using them at times when Excel requires them to alter the order of calculation.


OzGrid Business Applications