Time Calculations

C

Chris

I need a little help with a query that I'm making involving time calculations.
In my query I have two columns: [Startime] and [Endtime].
I have already added a column in my query that calculates the difference
[TotalTime].

I need a column [First 30 min] that gives me a "1" when the TotalTime is
greather than 00:01. (That I have found to with : First 30 min:
IIf([TotalTime]>0;"1";"0"))

Now I need a column [Next 15 Min] that gives me the time that is left over
when I substract 29:59 minutes from [TotalTime]. The result rendered in that
column must be shown as a number of the total of quarters left over.

Does anyone have a simple idea?

Thanks in advance

Chris
 
C

Chris

Thanks already for your help.
I need to round down.
How do I implement this in my field?

Grtz
 
C

Chris

Hi Allen,

I made a new column for the rounddown. That works fine.
Is it also possible to set this Rounddown in the same column as QtHrs?
I am not use to use to working with two functions in one field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top