Please can you suggest me , How to get defference between two dates
My date format is : 4/27/2009 9:33:17 AM… start time and end time is same DATE data type .
Appreciate your help
kolla99 (BOB member since 2005-11-15)
Did you try using DaysBetween() function?
Jansi 
(BOB member since 2008-05-12)
it is giving me in days … as i would need in time …
Basically i would like to calculate the the total time taken from the load start date and load end date
If i’m not clear , please let me know . Thanks
kolla99 (BOB member since 2005-11-15)
Thanks Jansi,
I tried with the below formula
=DaysBetween([Load Start Time] ;[Load End Time]) * 86400 + ( ToNumber(FormatDate([Load End Time];"HH")) * 3600 + ToNumber(Left(FormatDate([Load End Time] ;"mm:ss") ;2)) * 60 + ToNumber(FormatDate([Load End Time] ;"ss"))) - (ToNumber(FormatDate([Load Start Time];"HH")) * 3600 + ToNumber(Left(FormatDate([Load Start Time] ;"mm:ss") ;2)) * 60 + ToNumber(FormatDate([Load Start Time] ;"ss")))I got the out put some thing difference for the dates between load start time and load end time is 2769
2009-04-28 10:52:37 PM - 2009-04-28 11:38:46 PM
expecting is - 0:46:09 9 ( hh:Mm:ss)
Please suggest me
kolla99 (BOB member since 2005-11-15)
Have you applied the proper formatting? 2749 is the number of seconds in the time you are expecting.
hcadar1 
(BOB member since 2008-04-25)