Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 10-13-2015, 02:07 PM
Haha88 Haha88 is offline Windows 8 Office 2010 32bit
Advanced Beginner
 
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 Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,393
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
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


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


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft