View Single Post
  #14   Report Post  
jerry_maguire jerry_maguire is offline
Junior Member
 
Posts: 25
Default Try this:

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