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]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 01:37 AM.