ExcelBanter - time conversion

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - time conversion (https://www.excelbanter.com/excel-worksheet-functions/210525-time-conversion.html)

GAIDEN

time conversion

how do i convert 6.12 hours to its time equivalent 06:07:12? i tried custom
formatting using h:mm:ss but i get 2:52:48.

T. Valko

time conversion

Divide by 24 then format in the Time style of your choice.

A1 = 6.12

=A1/24

--
Biff
Microsoft Excel MVP

"GAIDEN" wrote in message
...
how do i convert 6.12 hours to its time equivalent 06:07:12? i tried
custom
formatting using h:mm:ss but i get 2:52:48.

Sheeloo[_3_]

time conversion

Divide by 24 and format as h:mm:ss

"GAIDEN" wrote:

how do i convert 6.12 hours to its time equivalent 06:07:12? i tried custom
formatting using h:mm:ss but i get 2:52:48.

GAIDEN

time conversion

thanks, that worked

"Sheeloo" wrote:

Divide by 24 and format as h:mm:ss

"GAIDEN" wrote:

how do i convert 6.12 hours to its time equivalent 06:07:12? i tried custom
formatting using h:mm:ss but i get 2:52:48.

All times are GMT +1. The time now is 11:45 PM.