Back to lesson
1. If the value 0.5 resided in a cell, and you formatted it with a time format, what would the result be?
1900-01-01 12:00:00 AM
2. If cell A6 holds the time of 8:00 AM, B6 holds the value 7.5 and D6 holds the formula =A6+C6 formatted as a time, what formula would you need to put in C6 to make D6 return 3:30 PM?
3. Assume that A6 holds a time of 8:00 AM and B6 holds a time of 4:00 PM. What formula would we need to use to calculate the number of hours elapsed between the two?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement