https://bugs.documentfoundation.org/show_bug.cgi?id=160408
--- Comment #1 from ady <adylo811...@gmail.com> --- If you introduce a value such as 04:30 in a cell that is formatted as General/Standard, Calc should recognize the value as a Time format. A value such as 0430 (without the colon character) is not automatically recognized as a Time type of value. So the result, as a General type is 430, which is an integer number. Converting an integer number to Time format means "12:00:00 AM". n.0 > 12:00 AM n.25 > 06:00 AM n.50 > 12:00 PM n.75 > 06:00 PM So, 0.1875 (the so-called "date-time serial value") would be displayed as 4:30 AM when formatting the cell as Time format. That is for Time format. Then you have also Time Differences. There are several Date/Time-related functions that could be useful too. I would suggest searching the Help content. IMO, NAB. -- You are receiving this mail because: You are the assignee for the bug.