Time Calculation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Daywalker - 30 Mar 2006 21:17 GMT

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

Reply to this Message

Peo Sjoblom - 30 Mar 2006 21:45 GMT

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

Signature

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

> Hi,
>
[quoted text clipped - 17 lines]
>
> Daywalker

Reply to this Message