Converting Times

[anna f]

I am having a brain blurb- how do I convert a time (x:xx) into a decimal? I have a calc field that shows the time elapsed between two dates/times in hours:minutes. I need to count how many records have a time of less than 1 hour, between 1 and 3 hours, and over 3 hours.

Thnx!

[Lee Smith]

Wouldn't X:XX be something like a time such as 3:45 PM (AM)?

Wouldn't the difference between 3:45 PM (AM) and 5:14 PM (AM) 1 Hour and 30 Minutes (1.30) ?

90 minutes / 60 minutes = 1.5

HTH

Lee

[LaRetta]

Also, there is no such time x:xx. I assume you are DISPLAYING it that way unless you've converted it to text instead. But time fields are always total seconds, so:

Let ( t = Div ( timeField ; 60 ) ;

Case (

t < 60 ; "whatever result if less than an hour" ;

t :less: 180 ; "whatever result if 1-3 hours" ;

"whatever result for over 3 hours"

)

)

Since your result isn't a decimal 'less than one hour, 1-3 hours and over 3, why bother with the decimal inbetween?

[comment]

How about:

Choose (

( TimeElapsed ≥ 3600 ) + ( TimeElapsed > 3*3600 ) ;

"less than 1 hour" ;

"between 1 and 3 hours" ;

"over 3 hours"

)

[anna f]

Thanks- this worked like a charm and was simple, as I suspected. I didn't try the Choose suggestion yet but I will.

-A