Hi all, I am trying to use orgmode to bill for time. My idea is to add a column that multiplies the elapsed time column by an hourly rate. Unfortunately, the elapsed time is interpreted (I believe) as a fraction in calc, so, for example, a time of 0:58 becomes a zero.
Is there a way to make the elapsed time get formatted as a decimal, or a function to convert it to a decimal, so I can multiply the time by a decimal and get teh right answer. Here is what I'm getting now, using 50 as a multiplier: | Headline | Time | | | | |---------------------------------------------------------------------------+---------+-------+------+-------| | *Total time* | *28:09* | | | 0 | |---------------------------------------------------------------------------+---------+-------+------+-------| | Lawsuit for Debt Against Rose Funding, LLC (1016-cv18431) | 28:09 | | | 0 | | Activities | | 28:09 | | 0 | | DONE Activity Log | | | 0:05 | 0 | | DONE Draft Complaint for Damages | | | 5:40 | 25:4 | | DONE Meet with Kevin Jones and Elizabeth Bennett re Complaint | | | 0:32 | 0 | | DONE [#A] Motion for Appointment of Private Process Server | | | 1:24 | 25:12 | | DONE [#A] File Affidavit of Service with Court | | | 0:25 | 0 | | [2010-07-27 Tue 11:16] Phone call from Mark Sheister | | | 0:11 | 0 | | Research regarding compulsory counterclaim, res judicata | | | 1:23 | 50:23 | | Work on brief in opposition to motion to dismiss. | | | 3:03 | 50 | | Prepared for Hearing | | | 0:24 | 0 | | Hearing on Case Status (Div 25:7th Flr) <2010-10-19 Tue 09:00> | | | 0:30 | 0 | | Hearing on Motion to Dismiss <2010-11-30 Tue 09:00> | | | 1:15 | 10:3 | | Hearing on Motion to Dismiss <2010-12-21 Tue 09:00> | | | 1:09 | 50:9 | | Status Hearing <2011-01-25 Tue 09:00> | | | 1:31 | 50:31 | | Status Hearing <2011-04-26 Tue 09:00> | | | 1:42 | 25:21 | | Called Kevin [[bbdb:Stacy]]. Left voicemail to call re settlement offer. | | | 0:04 | 0 | | DONE Call [[bbdb:Sheister]] with counter offer. | | | 0:06 | 0 | | [#B] Draft Interrogatories for Rose, Swords | | | 4:48 | 25:6 | | Argo Status Hearing <2011-06-28 Tue 09:00> | | | 1:09 | 50:9 | | Letter of Discovery Deficiencies | | | 2:48 | 25:12 | #+TBLFM: $5=$4*50;Df2 #+END: Reagards, -- ==================================================== Daniel E. Doherty Up the airy mountain, Down the rushy glen, We daren't go a-hunting, For fear of little men. --- William Allingham (Donegal, Ireland)