Calculating Time Difference

[hinkwale73]

Hello all,

I need help creating formulas to calculate the time spent on break and the total hours worked on a given day. The total hours worked should be Clock Out Time minus Clock In Time minus Time on Break. Time on Break should be column C minus Column B. Please see excel Time Log picture inserted

Help rendererd will be greatly appreciated

 

[steve the fish]

Are those formatted date times? To check use =ISNUMBER(A1) where A1 is one of the date times. What are you proposing to do with people who seem to not ever come back from break?

 

[hinkwale73]

Yes it is a date time format and I'm trying to calculate the time spent on breaks and the total hours worked each day. There is logic in VBA for people who don't log back in after their breaks and my focus is to calculate the time in between those date time formatted Clock In and Out

 

[steve the fish]

Well if they are true date time you just go end date time minus start date time minus break end date time plus break start date time. Date times to excel are just numbers.