I have a DateDiff formula for elapsed time between two date/time fields extending over24 hours.
Elapsed Time: Abs(DateDiff([[Start],[Finish])\60) & Format(Abs(DateDiff("n",[Start],[Finish]) Mod 60),"\:00")
This returns a Short Time( hh:mm)
I have resolved the negative value problem using the Abs function, HOWEVER
I need to Group the resultant values into ranges - for example
> 4
> 8
>12
>24
>48
I seem to have no issues until I try to report > 24 - probably because I need to group on a decimal not a time value.
How can I convert the short time to a decimal - I have tried and failed consistently to find a solution ???
Thanks for any help with this mateer
Kind regards
Garmani
Elapsed Time: Abs(DateDiff([[Start],[Finish])\60) & Format(Abs(DateDiff("n",[Start],[Finish]) Mod 60),"\:00")
This returns a Short Time( hh:mm)
I have resolved the negative value problem using the Abs function, HOWEVER
I need to Group the resultant values into ranges - for example
> 4
> 8
>12
>24
>48
I seem to have no issues until I try to report > 24 - probably because I need to group on a decimal not a time value.
How can I convert the short time to a decimal - I have tried and failed consistently to find a solution ???
Thanks for any help with this mateer
Kind regards
Garmani