Calculate total time worked from signing in and signing out

as long as the times do not go over midnight just =b2-a2 and format as [h]:mm

or multiply by 24 to make it decimal hours and format as a number

If the times go through midnight let me know and I will amend the formula perhaps
if(b2<a2,24-a2+b2,b2-a2)

regards

Dav

Originally Posted by sumankhs

I would like some help on how to calculate total number of hours and minutes worked from 2 columns labelled A2 'signed in' and B2 'signed out' and the result in C2.

in cell C1 put

=B2-A1

and format cell C1 as [h]:mm