I have 2 fields - Start Time and End Time - both are Time of Day Fields.
I am trying to create a crosstab schedule report where the EE's name is on the left, and group columns of dates and Start /End time. I can only do the Start and End times in a crosstab report if the times are converted to numbers.
Here is the formula I have used:
It converts 9:00 am to 9, but doesn't convert 5:30 pm to 5.5 or 5.3 - returns only 5.00. I need it to convert to 5.50 or 5.30. Any idea?