Time Calculation

  • Thread starter Thread starter Daywalker
  • Start date Start date
D

Daywalker

Hi,

I am trying to get a sum value of time, trying to get it to input th
time only and calculate the total number of hours and minutes worked.

ie: of what I want it to do

Start Time 11.05 (24 hour clock)
Lunch 0.30 (minutes)
Finsh Time 19.00 (24 hour clock)

Total Minutes 0.445
Total Hours 7.10

Have tried many ways of doing this, but cannot get it to work.

Can anyone help ?

Cheers,

Daywalke
 
I don't know if you have changed the settings and 11.05 is equal to 11:05,
if not enter the values as

11:05
00:30
19:00


then use end-start-lunch

that will give 07:25 (formatted as [hh]:mm)

now if you want to apply that towards an hourly pay rate use

total_hours*24*pay_rate

format as number, general or currency


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Back
Top