Back to School Sale -
20% off all courses with code BTS2019
Search for courses or lessons
Redeem a coupon
Start free trial
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
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?
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?