Microsoft Office Forums

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: 75
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, 11 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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:30 PM.


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