Thread: Time difference overnight
View Single Post
 
Old 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
medavidcook is on a distinguished road
Default
Quote:
Originally Posted by Pecoflyer View Post
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
Reply With Quote