Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want certain format to get difference in two times in total hours: minutes and seconds
Like in attached picture of excel format
you must know the format of time field
then use interval function like this
interval(timefield1- timefield2,'hh:mm:ss')
here for both timefield format should be same if don't then before interval function use timestamp# function
What you hava , Timestamp or only time ?
time!
look at the picture attached
its 37hours:30minutes:55seconds
you must know the format of time field
then use interval function like this
interval(timefield1- timefield2,'hh:mm:ss')
here for both timefield format should be same if don't then before interval function use timestamp# function
Try Date(Field,’hh:mm:ss’)
offcourse that would not work!
date is not required
Try this hope it will help
=interval(time1-time2,'hh:mm:ss')
Try this
=Interval(Timestamp#('26-11-2013 02:15 PM','DD-MM-YYYY hh:mm TT')-Timestamp#('24-11-2013 01:30:30 PM','DD-MM-YYYY hh:mm:ss TT'),'hh:mm:ss')
Here first time field need to be greater the second time field other wise u will get the minus value.