Forum Discussion
total time calculation
Ozyborn You need to use a slightly different formula to calculate the duration, allowing for a start time before midnight and an end time after midnight.
=end-start will result in a negative number that can not be represented in the [h]:mm format.
Use =MOD(end-start,1) for all your calculation as it will give the correct answer in all situations.
Attached a file with some examples.
Ozyborn You need to use a slightly different formula to calculate the duration, allowing for a start time before midnight and an end time after midnight.
=end-start will result in a negative number that can not be represented in the [h]:mm format.
Use =MOD(end-start,1) for all your calculation as it will give the correct answer in all situations.
Attached a file with some examples.
- Thank you. Saved me a few hours on mind numbing searching my books.
