calculating time 6:00pm - 8:00am we track the amount of time it took to return a call: the call came into your voicemail after hours: 6:00pm and you returned the call the next day at 8:00am.

how would your write a formula in excel?

A date is actually stored as a number where a full day equals one. So you can subtract to find the difference, assuming your date includes time like: “10/14/2011 5:04”

=(C1-B1)*24 & " hours"

The above formula shows the difference in two dates based on hours; remove the *24 and it's days.

Ask Your Question

Weekly Poll