You could

-Create a daily rate (rate * 24) and then break down the resulting days and hours separately

-Convert the time to seconds then add the seconds and divide by 3600

-Store the data in the database as real data type with the minutes to the closest 10th of an hour

Ben Johansen - http://www.pcforge.com
Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm
Authorized MDaemon Mail Server Reseller
http://www.pcforge.com/AltN.htm

-----Original Message-----
From: Marc Leblanc [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 1:49 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Adding time

 

Hi all,

 

I was wondering if anyone out there tried to add time under this format "00:00". Let's say I worked 10:00 (10 hours)on something and 17:00 (17 hours) on something else. The result has to be 27:00 and not 1 day, 3 hours... I have to create a time sheet of hours spent. If you guys have any idea on how to do this please reply.

 

Thanks! 



Marc Leblanc

________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf

Reply via email to