Biff

Posts: n/a

Hi!

A1 = start time - 7:00 PM
B1 = end time - 7:00 AM

=B1-A1+(A1B1)

Format as h:mm = 12:00

=(B1-A1+(A1B1))*24

Format as GENERAL = 12

Biff

-----Original Message-----
How do I add times for a night shift i.e., 7:00 PM to
7:00AM.
.

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
Copy from worksheet to another x times	Union70	Excel Discussion (Misc queries)	0	March 7th 05 09:03 PM
Formula for averaging times	Denise	Excel Discussion (Misc queries)	1	January 28th 05 04:05 PM
Adding times together	[email protected]	Excel Worksheet Functions	2	January 16th 05 10:19 PM
SUMPRODUCT ON TIMES	Bob Phillips	Excel Worksheet Functions	1	January 13th 05 05:28 PM
Adding/Averaging Times in Excel	JD	Excel Discussion (Misc queries)	2	January 5th 05 05:07 PM

All times are GMT +1. The time now is 02:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us