Ravi Sir's Cards › Excel
Sleep Tracker in Excel (card 2 of 2)
Revision card 2 for Sleep Tracker in Excel: Hours slept, even past midnight: =MOD(E6-D6,1)*24 gives 7.00; Goal met?: =IF(F6>=$B$3,"Yes","No") gives No. Includes an example data table.
Read card text
What this card says
2 for Sleep Tracker in Excel: Hours slept, even past midnight: =MOD(E6-D6,1)*24 gives 7.00
Goal met?: =IF(F6>=$B$3,"Yes","No") gives No. Includes an
Example
data table
Learn this in the lesson: Sleep Tracker in Excel: Calculate Hours Slept (Even Past Midnight) and Weekly Averages