Excel and time

Hi there,

How do you work with time in a spread sheet. I have a bunch of times, as how long it takes to do a task. I have converted them all to minutes. I want to add them up and display them as hours and minutes.

basically here are some of the values I have:
26.66666667
19.16666667
7.16666667
etc

How do I display them as
26:40
19:10
7:10
i.e. 26 hours and 40 minutes

How do you do this????

Hi
If you want to convert decimal numbers to hours and minutes divide them by 24 and custom format cell to: [h]:mm to give you a time format.

DBY