Steps
Begin by typing in =TEXT(
Select or type in the range reference that contains the numeric value you want to convert B3,
Divide the numeric value by 24.
Type in the format code that includes h, m and s placeholders “[h] “”hours,”” m “”minutes, “” s “”seconds”””
Close the formula with ) and press Enter to complete it.
Hope this helps. You can get more tips about excel on
O365CloudExperts
Regards,
Jerry