View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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?