daixienz
Nov 24, 2011, 03:04 AM
Hi, I'm trying to make a formula for the total hours if time in and time out,
JBeaucaire
Nov 24, 2011, 07:46 AM
A1: Time In
B1: Time Out
C1: =(B1-A1)*24 (format this cell as General)
If you will ever have an instance where someone clocks in on one day and out early the next day, like a shift that runs from 11pm-8am, then the formula will need to be longer to take that into account:
=((B1-A1)+(A1>B1))*24