#1
|
|||
|
|||
Time difference overnight
another question I am trying to work out for night shift I start at 22:00 and finish 06:00 and when i do the formula it shows -16 hours but should be 8 any ideas Last edited by Pecoflyer; 06-04-2015 at 05:02 AM. Reason: Other question - New thread created |
#2
|
||||
|
||||
Try =MOD(end_time-start_time,1) and format as needed
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
hello,
sorry for the delay, on the back of this how do i do it so it shows 7hrs 30 mins as need to take lunch into account thanks |
#4
|
||||
|
||||
Depending on how your result is formatted subtract 1/48 ( sexagesimal) or 0.5 ( decimal)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
What is difference between Delete and Trash Folders | sportflyer | Outlook | 0 | 02-04-2015 09:17 AM |
Whats the difference between Office 365 and 360? | lordknight | Office | 2 | 08-04-2013 12:20 AM |
Difference between export and archive? | Jennifer Murphy | Outlook | 0 | 07-31-2013 01:31 PM |
Insert picture options, what's the difference? | Jennifer Murphy | Drawing and Graphics | 3 | 10-09-2012 05:12 AM |
What is the difference between the category and the distribution list? | Jamal NUMAN | Outlook | 1 | 11-21-2010 09:31 PM |