Identifing total hours as a whole number
since one hour in Excel - 1/24 do as follows
=total_time*24*hourly_rate
format as currency or else you'll get a weird time value
--
Regards,
Peo Sjoblom
"Bob Morrison" wrote in message
...
I have set up a little spreadsheet using "start time" and "end time". The
resulting difference is expressed in hours and minutes. I would like to
use this figure to calculate pay. It is not doing that because of the
formating. Is there a way?
|