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 police officers should wear body cameras?

Discuss in The Lounge

Poll History