Back to lesson
1. Suppose a cell contains the value 0.5. What is returned when this value is formatted with a date and time format?
1900-01-01 12:00:00 PM
1900-01-01 12:00:00 AM
2. Suppose cell A6 contains the time 8:00 AM, B6 the value 7.5 and D6 the formula =A6+C6 formatted as a time. Which formula for C6 returns the time 3:30 PM for D6?
3. Suppose cells A6 and B6 contain the times 8:00 AM and 4:00 PM respectively. Which formula calculates how many hours have elapsed between these two times?
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement