Microsoft Office Forums find shift with start and end time

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-13-2015, 02:07 PM
Haha88 Haha88 is offline find shift with start and end time Windows 8 find shift with start and end time Office 2010 32bit
Advanced Beginner
find shift with start and end time
 
Join Date: Mar 2015
Posts: 46
Haha88 is on a distinguished road
Default 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,
Attached Files
File Type: xlsx Book2.xlsx (9.1 KB, 5 views)
Reply With Quote
  #2  
Old 10-13-2015, 11:30 PM
macropod's Avatar
macropod macropod is offline find shift with start and end time Windows 7 64bit find shift with start and end time Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,533
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

It's not exactly clear what you're after. Try:
=2-((C2-B2)*144<24)
in D2 and copy down.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
find shift with start and end time 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
find shift with start and end time Noob here - I need a shift calendar by days with count of shift. freeman Excel 8 09-12-2012 08:45 AM


All times are GMT -7. The time now is 10:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft