Time Calc

[Ben Ball]

I have a calculation that times how ling someone is in a record.

i.e TimeFinish - TimeStart = Actual Time

My problem is when a record is created at

23:30 and finishes the next day/morning at 00:30 I have a minus time calculated....

same thing applies if it were 12 hour clock. If not worse as it happens twice a day.

How can I over come this one?

[Raybaudi]

Hi

Assuming that you have 8 Advanced as shown under: "This Post", you can change your TimeFinish to a TimeStampFinish

and

your TimeStart to a TimeStampStart

The calc: TimeStampFinish - TimeStampStart ( result time ) will give you the correct Actual Time

[comment]

You could change your fields to Timestamp type. Alternatively,

TimeFinish - TimeStart + ( TimeFinish < TimeStart ) * 86400

should work, provided no one stays long enough to cross midnight more than once.

Filemaker's time calculations are ALWAYS based on 24-hour clock.

[Ben Ball]

Excellent... Thankyou.