Thread: times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ANGUS ANGUS is offline
external usenet poster
 
Posts: 2
Default times

Hello

I am trying to produce a spreadsheet that will calculate
the hours people have worked and how much they have earned.

There are 4 columns, Start Time, End Time, Breaks and Total

I would like it to be possible to enter the Start Time ,
End Time and Breaks and have the Total calculated for me.

So far I have achieved this, but the resulting total is
still expressed as a time.
For Example,if
Start Time = 09:00
End Time = 17:00
Breaks = 00:30
then the Total = 07:30 indicating 7 hours 30 mins worked.
However I need this to be displayed as 7.5 hours worked,
in order to multiply it by the hourly rate of pay.

Does anyone know a way of doing this?

Thanks in advance