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)

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)

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)