Calculation of time difference?

[Vipin Vijayan]

I have a doubt regarding the calculation of time difference.

I have an excel file includes the start and end time of each processors. i need to get the exact working duration of each employees. the problem is the that the duration may be more than 24 hours, in these situations, i am not getting the accurate time. There is only start time and end time, not having the date.

Is there any idea to solve my problem?


Thanks

Vipin

 

[Mike H..]

I have a doubt regarding the calculation of time difference.

I have an excel file includes the start and end time of each processors. i need to get the exact working duration of each employees. the problem is the that the duration may be more than 24 hours, in these situations, i am not getting the accurate time. There is only start time and end time, not having the date.

Is there any idea to solve my problem?


Thanks

Vipin

Hi,

If you format the cell like below then it won't roll over to zero after 24 hours.

[H]:MM

If you don't have a date then it's going to be difficult to establish whether a time difference runs over a day. Attach some sample data in a workbook.