RE: Witango-Talk: Adding time

[Robert Shubert]

I would keep the hours and minutes in separate columns (or @tokenize on the colon) then just sum() the columns. You’d have to convert > 59 minutes into hours, but that’s a simple math step.   Robert   -----Original Message----- From: Marc Leblanc [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 3: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