hi,
I have two columns in which the date and time is shown on each column. Now i need to add another column which represents the difference between those two. But when i create a formula using “days between” … i get only the difference in days. how can i get even the difference in time. For ex if there is no difference in date i should get atleast the difference in time.
thanks in advance.
Also I am using BO 5.1
BOB_US (BOB member since 2006-03-16)
Time difference is something that’s been discussed many times. A simple search lead me to:
https://bobj-board.org/t/60815,
https://bobj-board.org/t/21735 and
https://bobj-board.org/t/61868.
jobjoris 
(BOB member since 2004-06-30)
Hi,
you can use the below formula to find the time difference
=daysbetween(date1,date2)-formatdate(date1,’‘HH’)+formatdate(date2,‘HH’)
gokulBalaji 
(BOB member since 2006-01-03)
Thanks gumalty,
But dont know why that formula is not working …
I even used this formula. but I get negative results if end and start day is same… Added to that, i ain’t getting the required result.
=(DaysBetween(<Start Date/Time> ,<End Date/Time>)*24)-ToNumber(FormatDate(<Start Date/Time> ,“HH”))+ToNumber(FormatDate(<End Date/Time> ,“HH”))
Start date : 01/01/2006 08:00:00 (hh:mm:ss)
end date : 01/01/2006 08:02:20 (hh:mm:ss)
The result should be displayed in this format
0.0(days) 00:02:20(hh:mm:ss)…
please help …
BOB_US (BOB member since 2006-03-16)
PLease could anyone help me with this problem…
I did search the forums but was not getting proper results…
thanks in advance…
BOB_US (BOB member since 2006-03-16)