Calculation of total time.

[crapmind]

I need to calculate how much time an individual of my team devotes to a particular work. Thats why i have added 2 columns to my time-sheet, which records start time and end time of a particular work. I deduct start time from end time to calculate total time taken by that individual.

Time format is 13:30:55

The solution works fine when an individual starts work at 18:30:35 and finishes within 23:59:59. But if finishing time exceeds that time, we move to the next day. So the time recorded will be something like 01:20:25.

My existing formula does not provide me the desired result.

How to solve the problem

[VBA Noob]

Try

=(B1-A1+(A1>B1))

VBA Noob

[CaptainQuattro]

I need to calculate how much time an individual of my team devotes to a particular work. Thats why i have added 2 columns to my time-sheet, which records start time and end time of a particular work. I deduct start time from end time to calculate total time taken by that individual.

Time format is 13:30:55

The solution works fine when an individual starts work at 18:30:35 and finishes within 23:59:59. But if finishing time exceeds that time, we move to the next day. So the time recorded will be something like 01:20:25.

My existing formula does not provide me the desired result.

How to solve the problem

Another way to deal with this would be to add 2 more columns, one for starting date, and one for ending date.

Total time elapsed would then be calculated as Starting Date + Starting Time -(Ending Date + Ending Time)

To display the result as hours and fractions of an hour, multiply by 24 and format the cell containing the result as "Number."

[crapmind]

thanks a lot mod