Total elapsed time w/date and time picker 6.0 (sp4)

[bfraser]

Happy Monday


I have an equipment downtime document (Excel 2007). F2 has the start date of the equipment downtime that uses the MS Date and Time Picker. G2 has the time, that is selected from a drop down list. L2 has the end date (using the dtpicker) and M2 has the end time, selected from drop down. How do I calculate the total downtime?


F2 G2 L2 M2

Start date Start time End date End time

 

[Hui]

Bfraser


Try =+(L2+M2)-(F2+G2)

and then change the cell format to [h]:mm:ss

 

[bfraser]

thxs