Posted to microsoft.public.excel.worksheet.functions

Lynda S

Posts: n/a

formula to calulate length of time

I need to create a formula that displays the length of stay between to dates
in a cell. For example the length of time between date 1 = 2006/01/06 12:30
pm and date 2 = 2006/01/13 10:30 am. What is the time frame here in hours.

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
Formula is entering a default time when it comes across an empty cell..	Howie	Excel Worksheet Functions	10	November 16th 05 11:34 AM
How can I correct this Time formula	John	Excel Worksheet Functions	11	November 4th 05 03:57 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
time formula question...	Greg	Excel Discussion (Misc queries)	5	February 25th 05 10:11 AM
Time / Formula to look at time difference	carl	Excel Worksheet Functions	5	November 8th 04 06:59 PM

All times are GMT +1. The time now is 04:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us