Time over 24hrs

[jlg5454]

Hi,

I'm unable to report time over 24 hours such as 37:20:00.

This is an reference to a field that is in seconds. I tried this function ss: 24*Int([SumOfScheduled])+Format(([SumOfScheduled]),"hh") & Format(([SumOfScheduled]),":nn:ss") and it did not work. For ex. I had 134400 in secs and the query returned 3225600:00:00.

Thanks,

Joe

 

[SkipVought]

Hi,

iif([SumOfScheduled]>1, then int([SumOfScheduled]*24),Format([SumOfScheduled],"hh"))&":"&format([SumOfScheduled],"mm:ss")

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[SkipVought]

oops..

int([SumOfScheduled]*24)&":"&format([SumOfScheduled],"mm:ss")

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[jlg5454]

Thanks for the reply.

I'm still having problems. I used what you provided "int([SumOfScheduled]*24)&":"&format([SumOfScheduled],"mm:ss")"


and get the following for ex. on 134400 secs 3225600:00:00

 

[SkipVought]

I missed that your [SumOfScheduled] is in SECONDS. You first stated that it was TIME (which is in DAYS)

convert [SumOfScheduled] to HOURS in the INT function and then convert [SumOfScheduled] to DAYS for the Format function.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[PHV]

24*Int(SumOfScheduled/86400)+Format(SumOfScheduled/86400,"hh") & Format(SumOfScheduled/86400,":nn:ss")

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[jlg5454]

Thanks PHV

I ended up using this :
Format([SumOfScheduled]\(60*60),"00") & ":" & Format(([SumOfScheduled]\60) Mod 60,"00") & ":" & Format([SumOfScheduled] Mod 60,"00")