Date and Time Calculations (Grade 12 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
How Excel stores dates
How Excel stores dates
As numbers: days since 1st January 1900
How Excel stores times
How Excel stores times
As decimal values: fractions of a day
TODAY() function purpose
TODAY() function purpose
Inserts current date automatically
NOW() function purpose
NOW() function purpose
Displays current date and time
DAYS() function argument order
DAYS() function argument order
=DAYS(end_date, start_date) - end date first
Formula to calculate age from birth date
Formula to calculate age from birth date
(current_date - birth_date)/365.25
Why use 365.25 in age calculations
Why use 365.25 in age calculations
Accounts for leap years every 4 years
Convert time difference to hours
Convert time difference to hours
Multiply by 24
Formula to determine quarter from date
Formula to determine quarter from date
=ROUNDUP(MONTH(date)/3,0)
What time value 0.5 represents
What time value 0.5 represents
12:00 PM (noon)