Time in = military; time out = military; lunch = minutes [ie 30 not .5]

I need the formula to calculate actual hours worked to decimal time.

Example

Time in: 08:00

Time out: 16:45

Lunch: 30

Actual Hours: 8.25

There are a great many freeware scheduling/timesheet templates available

out on the web, if you haven't already, I would advise you to look around,

see what you like and use it.Here is the MS site:

http://office.microsoft.com/en-us/t...But in case you really want to do it, here is one way:

A B 1) Time In 7:20 2) Time Out 12:00 3) Time In 13:00 4) Time Out 15:25 5) 6) Lunch 1:00 7) Total Hours 7:05

Format cells in Column B as Custom, [H]:MM

the square bracket is required.In Cell B6 enter the formula: =SUM(B3-B2)

In Cell B7 enter the formula: =SUM(B4-B3)+(B2-B1)MIKE

OOPS, forgot you wanted the total time in decimal format. Change the format in Cell B7 to: Number

Change the formula in Cell B7 to: =(SUM(B4-B3)+(B2-B1))*24That should give you the total time in decimal format.

MIKE

Ask Your Question

Weekly Poll

Do you think end-to-end encryption should be banned?

Discuss in The Lounge

Poll History