Posted to microsoft.public.excel.misc

external usenet poster

Posts: 1

formula for hr worked that cross 12:00 am

I need the formula that will figure hrs worked in a shift that starts in one
day and ends in the next.
Excel 2003

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 to work out hours worked	Shazza	Excel Discussion (Misc queries)	4	January 21st 07 11:52 PM
Formula doesn't work this morning, but worked for 2 years now	Rhop	Excel Worksheet Functions	1	October 11th 06 01:54 PM
Need formula to calculate hours worked	BankC	Excel Discussion (Misc queries)	12	January 31st 06 05:38 PM
What is wrong with this IF formula, it worked fine for a while?	AC man	Excel Discussion (Misc queries)	4	January 10th 06 01:19 AM
Formula that will represent years & months worked	Pam	Excel Discussion (Misc queries)	5	August 29th 05 11:20 PM

All times are GMT +1. The time now is 12:24 PM.

About Us

"It's about Microsoft Excel"