How to Calculate no. of hours in a stipulated time?

M

MURUGANGENIUS

for example if a employee logs in at 5.00pm in the evening and logs out at
3.30am, how to calculate the no.of hours between 5.00pm and 3.30am, (date is
not captured)
 
T

Toppers

A1=17:00
B1=03:30
in C1, format as General:

=MOD(B1-A1,1)*24

Number of hours as decimal number

HTH
 
Top