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

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)

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

Try,

Start time in A1, end time in B1

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

Mike

"MURUGANGENIUS" wrote:

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)

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

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

=MOD(B1-A1,1)*24

Number of hours as decimal number

HTH

"MURUGANGENIUS" wrote:

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)