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

[Guest]

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)

 

[Guest]

Try,

Start time in A1, end time in B1

=(B1-A1+(B1<A1))*24

Mike

 

[Guest]

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

=MOD(B1-A1,1)*24

Number of hours as decimal number

HTH