Format Cells to calculate hours and minutes taken to complete task
Well, you could modify your formula so that the final result is
divided by 24 (ie putting it back into Excel time) and then format the
formula cell as an Excel time format ie
[h]:mm
(if tasks may take over 24 hours)
Alternatively, you could multiply by 60 in which case you will end up
with an integer value representing the number of minutes to complete
the task.
Hope this helps!
Richard
|