https://issues.apache.org/ooo/show_bug.cgi?id=124620
mroe <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Resolution|--- |NOT_AN_ISSUE --- Comment #6 from mroe <[email protected]> --- (In reply to Robert Hays from comment #4) > Just one of the ways I was trying to use it is: > I have a crop planted that is 45% ready to harvest, this would calcu. out to > X# of hours left, by adding this x# of hours to NOW() I would have the exact > time of day I would need to go harvest it, but this is not to be ,,,,, so > sad. > Sorry to have bothered you guys with this. You have to look how a spreadsheet is working. Let in cell B1 you X# hours. So you have simply to calculate: =NOW()+B1/24 - because 1 day = 24 hours Format the cell with "DD/MM/YYYY HH:MM:SS". -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
