So in your case, make sure the formatting of the cells are: :ss The brackets tell Excel that it should count the number of hours () or minutes () and not revert them to zero after 23 hours or after 59 minutes. In the custom format, you can use :mm:ss or :ss.
48 minutes and 20 seconds become: 0:48:20Ī third thing to consider is the formatting of the cells. Excel does not work with negative values for date/time, so subtracting to a negative value results in an error (cell with "#").Īnother challenge is to get Excel to understand that by 48:20 you mean 48 minutes and 20 seconds and not 48 hours and 20 minutes. Entering a time of 0:48:20 is actually Jan. Excel starts counting the dates from january 1st, 1900 12:00 am ( 12:00 a.m. Excel uses fractions of a day to store time.
0 kommentar(er)
