Creating formulas to calculate time on a 24 hr time clock

M

MWILLIAMS

I have to create a spreadsheet that will calculate total
hrs worked. I've tried several different ways but I guess
I don't know enough about building formulas to actually
make the thing work. For example, I used a basic formula
D3=A3-B3+IF(A3>B3,1)*12. This works to show the time but
not the number of hours worked. If an employee comes in
1/2 hour late, it does not properly calculate this. How
can I correct my formula?
 
A

Andy B

MW

I have tried your formula and it works fine (with start time in B3 and
finish time in A3). Format the reult as h:mm and it's OK.

Andy
 

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

Similar Threads

#VALUE error add'g formulas 1
Calculate time worked 1
Time calculations for Scheduled Time vs. Actual Time Worked 1
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
Time sheet template military hours problem 6
Calculating Time 6
Time punch & hours calculations 1

Top