If you work with time in Microsoft Excel you may need to calculate with it. For example; if you have a spreadsheet that is a timesheet, you may enter the start time and the time. In order to find out the total number of hours worked, you could manually enter the time, or you could get Excel to calculate for you.
As long as you enter time so Excel understands you will be able to perform any calculation. The standard English format is hours: minutes:seconds using the colon to separate. If there are no seconds you can leave them off ending with minutes. For example 10:30 or 13:27 are ok but 10. 30 will not be treated the same. You can also use am and pm if you do not use the 24 hour clock, ie 1:35pm.
When calculating time the answer may not appear how you would like. If I was adding up 8:00, 8:00, and 10:00 I might want the answer to be 26:00 or 26 hours. Excel gives me 2:00. Why does it do this? Because time works on 24 hours. When if reaches midnight it will add a day and start the time again. This does not help if you are work ing with a timesheet and want a total for the hours.
Excel can do this . It is called cumulative time. Create the sum as normal but change the time format using custom format to put [ ] around the h or hh to tell Excel you would like the cumulative or total in hours without days.
Katherine