Creating a Log Sheet in Apple Numbers

How to use Numbers on a Mac
In this episode I show you how to use Apple Numbers to create a running Log Sheet also known as a Time Sheet. This tutorial makes use of the following numbers features:
Pop-Up Menus
Sum Formula
Date Formula
Date Types
Duration Types
This tutorial is useful for anyone learning about Apple Numbers however it is aimed at beginners.
Check out my other tutorials for Apple Numbers:
• DAY(), DAYNAME(), and ...
• EOMONTH() function in ...
• EDATE() function in Ap...
• REGEX() and SUMIF() - ...
• DATEVALUE() function i...
• DATEDIF() function in ...
• DATE() function in App...
• Create CHARTS in Apple...
• SUM(), SUMIF(), and SU...
• HOUR(), MINUTE(), and ...
Mac Numbers Function
#numbers, #apple, #spreadsheet, #spreadsheettutorial, #date, #time #hour #minute #second #functions #dateandtime #log #logsheet #timesheet

[@JRossHunter]

Sometimes I learn things from your tutorials that I didn't expect to learn. Today it was how to "pre-format" a spreadsheet.

[@apple-a-day]

That's great to hear! Thanks!

[@nickt2159]

Excellent! Excellent! Excellent! I converted from Excel to numbers about a year ago. Your video showed me how much I have not learned on the basic simple things. No one covers the fundamentals like you. You give the examples, then explain/SHOW what could go wrong. It’s those fundamentals that hinder me from really advancing my knowledge robustly. Case in point … icon to copy cell formatting , then the compliment icon to paste that formatting on another(s) cells, rarely works for me. I haven’t yet figured out why. All the YT videos I have watched just speed over it like it’s so simple. Apparently it’s not. I am missing something. Do you have a video covering how to use? Could you please give us an Apple-A-Day and create one?

[@apple-a-day]

Hi there! Thanks so much for the kind words, it's very much appreciated. I'm glad you find these tutorials helpful. It sounds like you're having trouble with using Copy and Paste - I think the other channels gloss over it because they assume everyone is a seasoned Mac user. Perhaps there's an issue with your keyboard and the command key - maybe try using Copy and Paste from the Edit Menu to see if it works better for you from there. And it that solves your problem then you might have a keyboard issue. Also if you're coming from a Windows environment you might be pressing CTRL instead of Command just out of habit. Thank for watching and good luck!

[@thomashartmann5037]

@@apple-a-dayNot the “normal” copy and paste. His issue was using the copy and paste formatting.

[@elg3eco]

Thx. Very helpful

[@apple-a-day]

Great to hear! Thanks for watching!

[@YQGInBloom]

Great video! I learned a lot!

[@apple-a-day]

Thank you YQGInBloom! Thanks for watching!