Re: Time Totaling

Row2 and Row 4 are the start and end hour. However. I want to convert the minute to base 100 from base 60. That is why i have the elsif statments. Could i do

$start_total = $row[2].$start_minute
[download]

But this creates a problem if the minute is rounded to 1.0

Comment on Re: Time Totaling Download Code

Replies are listed 'Best First'.
Re: Re: Time Totaling by lestrrat (Deacon) on Aug 02, 2001 at 06:14 UTC
Dude! Read carefully the advices that we gave you ! I guess boo_radley was correct in pointing out "what exactly do you mean by decimal?" , cause judging by the way you are doing this, you somehow got our advices wrong Everybody was telling you to either: use epoch time, or use the database's native time format We were trying to tell you that you can't reliably compute the elapsed time by just having the starting hour, starting minute, end hour and end minute. If you want to do that, you must assume that those times were recorded within the same day, between 00:00am to 23:59pm. Otherwise, you always need to know the date to compute the time elapsed Is there some reason you can't change those entries?	[reply]

Replies are listed 'Best First'.

Re: Re: Time Totaling
by lestrrat (Deacon) on Aug 02, 2001 at 06:14 UTC

Dude! Read carefully the advices that we gave you !

I guess boo_radley was correct in pointing out "what exactly do you mean by decimal?" , cause judging by the way you are doing this, you somehow got our advices wrong

Everybody was telling you to either:

use epoch time, or
use the database's native time format

We were trying to tell you that you can't reliably compute the elapsed time by just having the starting hour, starting minute, end hour and end minute. If you want to do that, you *must* assume that those times were recorded within the same day, between 00:00am to 23:59pm. Otherwise, you *always* need to know the date to compute the time elapsed

Is there some reason you can't change those entries?

[reply]