Posted to microsoft.public.excel.misc

Stephen White Stephen White is offline

external usenet poster

Posts: 8

Time period spanning midnight

I am working on a time sheet.

Suppose in cell A1 I have a start time and in cell B1 a finish time in a
24hr format (say for example 23:00 or just 2300) and suppose that the
time between them spans midnight. So the two values might be

A1 21:30
B1 3:45

What is the neatest formula to calculate the number of hours between
them?

--
Stephen White )

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
find the difference between start time and end time when spanning.	wahoos	Excel Discussion (Misc queries)	8	January 18th 08 06:02 PM
Time after midnight	Steved	Excel Worksheet Functions	2	May 30th 07 08:10 PM
time around midnight	Mai-Britt	Excel Worksheet Functions	2	May 9th 07 01:05 PM
subtraction off time after midnight	Steved	Excel Worksheet Functions	2	May 24th 06 01:46 AM
Time calculation (in hh.mm) spanning more than one day	dtencza	Excel Discussion (Misc queries)	8	August 16th 05 09:49 PM

All times are GMT +1. The time now is 11:26 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us