Negative Time formats 2

[jlg5454]

Hello:

Does anyone know how to display -120 seconds to -hh:nn:ss format? I used NStart: Format([SUMOFSTART]/3600/24,"h:nn:ss") and this only reports a positive time value (00:02:00). How do I get the - sign in front? Any tricks that anyone knows?

Thanks,

Joe

 

[Remou]

How about:

Format([SUMOFSTART]/3600/24,"-h:nn:ss")

 

[jlg5454]

Thanks,

I tried that but it returns all values with a negative. I looking for a return of a negative or pos based on the field I'm formatting. (There's a mixture of neg and pos time values)

Joe

 

[SkipVought]

How about

NStart: iif([SUMOFSTART]<0,Format(Abs([SUMOFSTART])/3600/24,"-h:nn:ss"),Format([SUMOFSTART]/3600/24,"h:nn:ss"))

Skip,

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

 

[jlg5454]

Perfect! I can't believe I did not think of that.

Joe

 

[PHV]

I'd use this:
NStart: Format([SUMOFSTART])/3600/24,IIf([SUMOFSTART]<0,"-","") & "h:nn:ss")

 

[jlg5454]

PHV,

That worked too. It just needed another ( after format.

Thanks!