ExcelBanter - Convert time stored as decimalised number to time format

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Convert time stored as decimalised number to time format (https://www.excelbanter.com/new-users-excel/185504-convert-time-stored-decimalised-number-time-format.html)

Emma

Convert time stored as decimalised number to time format

Hello
How can I convert 3.5 hours to 3:30:00?
--
Emma

Mike Rogers[_2_]

Convert time stored as decimalised number to time format

Emma

A1/24 and formate as time

Mike Rogers

"Emma" wrote:

Hello
How can I convert 3.5 hours to 3:30:00?
--
Emma

All times are GMT +1. The time now is 05:23 PM.