Excel How ToLesson 122Free preview

Convert Time to Seconds

This lesson is part of Excel · All levels

Summary

Converting time into seconds is useful when calculating the duration of work or activity. The key is that Excel stores time as a fraction of a day, so the time value can be multiplied by 86400 (24 hours x 3600 seconds) to get a total of seconds.

Key points

The time value in Excel is a fraction of the day, say 0.5 = 12 hours.
Basic conversion: time value multiplied by 24 x 3600
Alternative: HOUR*3600 + MINUTE*60 + SECOND
TIMEVALUE converts the clock text to the time value of Excel

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.