Posted to microsoft.public.excel.misc

TBA

Posts: n/a

number of hours between two date/times

I have tried a number of the responses posted- sorry i can't seem to get it
right!
I want to calculate the number of days and hours between two date time values
e.g.

cell A1 start: 17/01/2006 16:12
cell A2 finish: 25/01/2006 10:00
cell A3 answer: 7 days 18 hrs

and is it possible to leave cells A1 and A2 in dd:mm:yy hh:mm format rather
than 'general'?

thanks for your help-

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
converting a decimal number to hours and seconds	jeda67	Excel Worksheet Functions	1	December 4th 05 09:35 AM
adding rows of hours and minutes to get a total	Tipps	Excel Worksheet Functions	1	November 4th 05 07:03 PM
How do I convert a number of minutes into hours and minutes?	gyrkin	Excel Worksheet Functions	3	August 18th 05 11:12 PM
Sumproduct help needed!	Trying to excel in life but need help	Excel Worksheet Functions	5	January 21st 05 09:07 PM
how to convert total hours (HH:MM) into decimal number	Greg T	Excel Worksheet Functions	1	November 17th 04 03:07 PM

All times are GMT +1. The time now is 08:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us