https://issues.apache.org/ooo/show_bug.cgi?id=124620
--- Comment #8 from Robert Hays <[email protected]> --- (In reply to Edwin Sharp from comment #7) > reopened The more I ponder on this issue the more I realize that what I was trying to do is just not practical, mainly because of fractions and there is no format for Hours. There is a format for DAYS & TIME but not for Hours, minutes or seconds. Your suggestion: did the trick with the added benefit of the date. 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". Thanks ever so much for the help, maybe some day someone will add a format for HOURS just for the hell of it. Robert (Bob) -- You are receiving this mail because: You are the assignee for the issue. You are watching all issue changes.
