Calculate difference by days and hours

		Microsoft Office Forums > Microsoft Excel > Excel
Calculate difference by days and hours

05-12-2013, 09:38 PM

macropod

Windows 7 64bit Calculate difference by days and hours

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

The formula is working OK, but you haven't applied the custom format (d h:mm:ss) needed to turn it back into a normal day/time representation.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare columns + calculate difference	Inatic	Excel	1	01-27-2013 08:00 AM
Insert picture options, what's the difference?	Jennifer Murphy	Drawing and Graphics	3	10-09-2012 05:12 AM
5 days/week during planning & 7 days/week during implementation	sanlen	Project	1	06-25-2012 04:17 PM
What is the difference between the category and the distribution list?	Jamal NUMAN	Outlook	1	11-21-2010 09:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 AM.