Hi, I'm trying to make a formula for the total hours if time in and time out,

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