I have a file in excel where there are five columns that have time formated
as basic numeric. Example: 30 minutes displays as 30, 10 hours displays as
10. How do I show these 5 columns as hours ?
Second question: I have an additional column where the time is displayed as
minutes (on the same worksheet as the five columns). I placed a formula where
it changes it to hours/minutes (= cell/1440) and then format the cell ([h]:mm.

Now I am trying to sum the 6 columns in the worksheet to get the total hours
and is not working. Any suggestions ?