Software

Ask something
Question Locked

Calculating hours worked in excel

0 helpful
4 replies

by zenda

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am trying to make a spreadsheet in excel to calculate my hours worked for example if i put my start time in cell A1 and my end time in cell B1 and my lunch in C1 how do i get the total hours worked in D1? is there a formula that does that?
This is a copy of my spreadsheet
Week 1
Day In Out Break Total OT
Monday 8:30 5:00 1:00
Tuesday
Wednesday
Thursday
Friday
Total

4 replies

by ksoniat

If you send me an email at the end of this post I can email you a copy.

I just use military time. Time in at AM, time out for lunch, time back from lunch and time and caluclate difference.

0800 1200 1300 1730 8.5

I don't get breaks but that would be easy to add (or subtract as the case might be)

by seanferd

Total =(out-in)

On a 24 hour clock, as noted by the previous poster.

This discussion is closed to new replies.