I am trying to finish a database that will track job time. I have a start time and a finish time. I was going to subtract the start time from the finish time and use that as a calculation for the duration of work. I understand that the results of that subtraction is in seconds. How do I convert that duration to hours and round that to the nearest half hour.

Take a look at the Rounding Time at Database Pros site Link

Lee, thanks for the link. Unfortunately, that file is created in FM7. I only have FM6. Going to need to upgrade soon, I'm sure, but can't do it now and still need to figure this out.

Any other help out there?

Dog gone it, he upgraded it.

I have an old copy of it around here, give me a couple of minutes, and I'll upload it.

Lee

It was a version 3 file, which I converted to v5

TIMEUP.FP5.zip

Edited May 7, 200817 yr by Guest
added file

oh, this is kinda funny, kinda not funny. I went back in and checked my calculation and I think it was working fine. I hadn't paid attention to the fact that I was working with around 23 minutes that I was trying to round and had not inspected the seconds. I found that the number was being rounded properly, where mentally I was rounding the other direction because I hadn't accounted for the seconds.

At any rate, here is the calculation I'm using. If you see any gross errors, I'd like to hear about them. But I think it's working correctly.

Finish time and start time are fields that I am populating with "current time" stamps at the click of a button.

Round(Round(([finish time]-[start time])/900,0) * 900 / 60 / 60, 2)

I would think one 'round' of rounding should be quite sufficient. If, as it seems, you want to round to the nearest quarter-hour (not half-hour as stated originally)

Round ( ( [finish time] - [start time] ) / 900 , 0 ) * 0.25