Time difference overnight

		Microsoft Office Forums > Microsoft Excel > Excel
Time difference overnight

06-04-2015, 02:24 AM

medavidcook medavidcook is offline

Mac OS X

Office for Mac 2011

Novice

Join Date: Jan 2014

Location: Cardiff

Posts: 15

Quote:

Originally Posted by Pecoflyer

Try =MOD(end_time-start_time,1) and format as needed

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:19 AM.