Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate times between dates and times in Excel | Excel Discussion (Misc queries) | |||
count text appear how many times & put in respec col??eg 1st times | Excel Discussion (Misc queries) | |||
Calculation of hourly rate times hours times 1.5 | Excel Worksheet Functions | |||
How are relay leg times or driving times entered and totaled? | Excel Worksheet Functions | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) |