how can I add time in excel to determine how long something took?
=(4:49 pm - 7:00 am) * 24
Make sure the times are formatted as times and the calculation is formatted
as a number.
Dave
--
Brevity is the soul of wit.
"Eric" wrote:
if I put down 7 am in one column and 4:49 pm in another, what formula do I
use to determine total time (9.81 hours)
|