I like to work with times as follows:
if
1 second = 1 / 86400 or 0.000012
then
12 hours = 0.5
24 hours = 1.0
36 hours = 1.5
48 hours and 1 second = 2.000012
and so on.
Regards,
Doug
> -----Original Message-----
> From: lkeeton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 06, 2001 13:29
> To: [EMAIL PROTECTED]
> Subject: Does anybody know the formula to convert difference
> of time in
> decimal
>
>
> I am working on a project that needs to get
>
> This particular format 1000.25
>
> 1000 representing hours and 25 represent minutes
>
> 1000 means a full 1000 minutes
>
> .25 means a quarter of an hour
>
> so essentially in english language we could say a thousand
> hours and about 15
> minutes
>
> I need a way in sql or simple programming to take a
> timpestamp(end time) and a
> timestamp(beginning time)
>
> for instance 12:00:00 is the end time
> 11:30:44 is the start time
>
> from here is where i need a solution that gets me the
> difference of these two
> times in a decimal format. Of course once I get that I may
> need to convert
> back in english to say there are 30 minutes and 44 seconds.
>
> any ideas
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
