how to write formula in Excel

October 13, 2011 at 09:04:58
Specs: Windows 7
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?

See More: how to write formula in Excel

Report •

October 13, 2011 at 14:54:00
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.

Report •
Related Solutions

Ask Question