you have to choose the lowest amount of time you want to look at and use that in a datediff function. Your result can then be displayed in different text formating...
e.g. datediff("h",date,daterequest) will give you the difference in hours but note that 1 minute can look like an hour if it compares "7:59 pm" and "8:00 pm"
once you get the hour value (or you can use whatever time portion if you want) you can use a calcuation to turn that into days and hours.
Edited by DBlank - 11 Sep 2013 at 11:35am
IP Logged
