How to Add Seconds, Minutes and Hours to a Time in Excel
Excel stores date value in integer number and time value in decimal number. 1 day = 24 hours 1 hour = 1/24 = 0.041666667 1 minute = 1/(24*60) = 1/1440 = 0.000694444 1 second = 1/(24*60*60) = 1/86400 = 0.0000115740740740741 To add seconds, minutes, or hours …