i want to add up hours in excel. for example: 8:15+8:15+8:15=24:45
T T. Valko Apr 19, 2007 #2 Just use the SUM function: =SUM(A1:A3) Format the cell as [h]:mm The [ ] keep the hours from rolling over after 24. For example, without using the [h]:mm format the result of the SUM formula would be 0:45. Biff
Just use the SUM function: =SUM(A1:A3) Format the cell as [h]:mm The [ ] keep the hours from rolling over after 24. For example, without using the [h]:mm format the result of the SUM formula would be 0:45. Biff
N Niek Otten Apr 19, 2007 #3 Just add them and format the result Custom as [h]:mm -- Kind regards, Niek Otten Microsoft MVP - Excel |i want to add up hours in excel. for example: 8:15+8:15+8:15=24:45
Just add them and format the result Custom as [h]:mm -- Kind regards, Niek Otten Microsoft MVP - Excel |i want to add up hours in excel. for example: 8:15+8:15+8:15=24:45
