find shift with start and end time

		Microsoft Office Forums > Microsoft Excel > Excel
find shift with start and end time

10-13-2015, 11:30 PM

macropod

Windows 7 64bit find shift with start and end time

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,369

It's not exactly clear what you're after. Try:
=2-((C2-B2)*144<24)
in D2 and copy down.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Shift Excel Cell after executing a macro for second time	LearningMacro	Excel Programming	2	01-08-2015 03:05 PM
when I loop a presentation how can I get a you tube video to play from the start each time?	PALFREE2005	PowerPoint	0	11-15-2014 07:12 AM
How to find all numbers that start with a paragraph?	csongi12xme	Word	7	07-22-2014 07:55 AM
Increase length of Start time drop down list	laguna92651	Outlook	0	07-11-2013 12:23 PM
Noob here - I need a shift calendar by days with count of shift.	freeman	Excel	8	09-12-2012 08:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:47 PM.