Formula

S

SusanM

Hello,
Having problem totaling time.
Employees have time sheets.
EX: In 7:15AM Out 11:00AM In 11:45AM Out 4:00PM
In the total hours today column, formula not working to
sum up total hours worked.
Very much appreciate advice on this,
As always, thank you all.

SusanM
 
P

Peter Atherton

-----Original Message-----
Hello,
Having problem totaling time.
Employees have time sheets.
EX: In 7:15AM Out 11:00AM In 11:45AM Out 4:00PM
In the total hours today column, formula not working to
sum up total hours worked.
Very much appreciate advice on this,
As always, thank you all.

SusanM
.
Susan

4:00pm is 16:00 hours. your formula will probably work if
you enter 16:00 for 4 in the afternoon.

if the times are in Columns D14 to G14 then daily hours
can be calculated with =E14-D14+G14+0.5-F14

If you have entered the knocking off time as 4:00 pm with
a space, remove the 0.5 from the formula.


Hours and minutes are fractions of a day so I added 12
hours (0.5 days) to the end time.

Regards
Peter
 
J

JE McGimpsey

One way:

A1: 7:15 AM
A2: 11:00 AM
A3: 11:45 AM
A4: 4:30 PM

A5: =A4-A3+A2-A1

format A5 as a time.

If any of your times may span midnight, instead use:

A5: =MOD(A2-A1,1) + MOD(A4-A3,1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top