Timesheet – Non Military Time

Topic

New Reply

My wife just started a new job (yeah!) and they have her using an Excel time sheet.

She asked me if I could help her get it to total the times, but I’m having a bit of trouble.

The columns she fills out are:
In, Out, In, Out

There are 2 Sub-totals. One for the first set of In/Out and one for the second set.

There is then a Total, the sum of the 2 sub totals.

All in all, it looks like this:
In Out SubTotal1 In Out SubTotal2 Total

Now, I could do this easily if I could get her to do military time, but no dice.

How can I set it up so that the SubTotals and Total work if she doesn’t use military time?

An example of a shift she worked is:
In 11:00
Out 2:00
In 2:30
Out 6:00

That makes SubTotal1 = 3 and SubTotal2 = 3.5 with a total of 6.5.

If it helps, the store is only open 8-6, so she never crosses midnight.

Any help is greatly appreciated!

Reply | Quote

Replies

If one isn’t using 24 hour time, then you must use AM/PM so that excel knows what is going on.

so if she enters 11:00 am and 2:00 pm, your calculations should be fine.

Reply | Quote

You could use an if statement.
if (IN > OUT, IN+0.5-OUT, IN-OUT)

0.5 = 12 hours in time format.

cheers, Paul

Reply | Quote