emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Orgmode] [BUG] Table formula with org-hh:mm-string-to-minutes


From: Sébastien Vauban
Subject: [Orgmode] [BUG] Table formula with org-hh:mm-string-to-minutes
Date: Tue, 05 Oct 2010 15:59:05 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (gnu/linux)

Hello,

I use the following table and formulas to convert HH:MM times to fractional
times, so that I can sum up the times (and convert them to money...)

| Task   | *HH:MM* | *Frac* |
|--------+---------+--------|
| Item 1 |   20:27 |  20.45 |
| Item 2 |    2:25 |   2.42 |
| Item 3 |    2:07 |   2.12 |
| Item 4 |    0:19 |   0.00 |
| Item 5 |    0:43 |   0.72 |
| Item 6 |    0:05 |   0.08 |
| Item 7 |    0:32 |   0.53 |
| Item 8 |    0:16 |   0.27 |
|--------+---------+--------|
|        |         |  26.59 |
#+TBLFM: $3='(/ (float (org-hh:mm-string-to-minutes $2)) 
60.);%.2f::@5$3=0.00;%.2f::@10$3=vsum(@address@hidden)

Everything is fine... but the item 4: 19 minutes get converted to 0.00 hour...
Why!?

It's not even because it's a small figure that would be rounded, or some such,
as 0:05 is well converted (to 0.08 hour).

Do you have a hint?

Best regards,
  Seb

-- 
Sébastien Vauban




reply via email to

[Prev in Thread] Current Thread [Next in Thread]