#1
|
|||
|
|||
find shift with start and end time
Hi all,
Can you please help to come up with a formula where I can find number of shift based on the start and end time as per attached. Many thanks, |
#2
|
||||
|
||||
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] |
Thread Tools | |
Display Modes | |
|
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 |