SubTrack Start Time from End Time

[rwn]

I have two times, a Start Time and an End Time. I need to find the total time between the Start and the End. This will indicate how long a shift runs. So the other issue could be a shift starts at 11:00 pm and ends the following day at 6:00am

I have this formula:
time({Shift_Day.End_Time}) - time({Shift_Day.Start_Time}).

But the value displayed is incorrect.

Thanks for any advise.

 

[jdemmi]

It is likely returning a value in minutes. If this is not what you want you can convert it to hours or hours and minutes.

If this is not that is happening can you display a sample start and end time and the results you see?

-- Jason
"It's Just Ones and Zeros

 

[jdemmi]

OOPS!.....SECONDS. It is likely returning SECONDS

-- Jason
"It's Just Ones and Zeros

 

[lbass]

Please tell us the datatype of your fields. If they are strings, please show how they display. You either need to add/keep the date as part of the calculation and then use:

datediff("s",{table.startdttime},{table.enddttime})

Or, if you need the calculation within a particular date, you can adjust each field in the same way, e.g., subtracting 6 hours from each, so that the results all fall within the same date.

-LB