Excel Basics #15: Date & Time Format & Calculations

The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#15 Video topics:
1)Excel Date Calculations and Format
2)Excel Time Calculations and Format
3)Date Format Math for formulas
4)Time Format Math for formulas
5)Calculate the Days an Invoice is Past Due
6)Create a Time Sheet in Excel (Time In and Time Out)
7)Payroll Time Sheet for wages and hours

Category:

Science & Technology

Tags:

• Excel
• Date
• Time
• Format
• Formula
• Math
• Payroll
• Sheet
• wages
• hours
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[crnadak87]

Thank you a lot but a have a huge problem!

How to turn off automatic date update, I want excel to enter a date based on if cell is empty or not (IF(isblank(A1)=true,"",today(­)) - but i don't want that date to be updated tomorrow, just to enter a today's date in that cell and to leave it like that for good...

Any ideas...

Btw your videos helped me a lot, already thankful !

[ExcelIsFun]

@crnadak87 , there is no way of preventing TODAY from updating. You would need VBA code. For Q like that post:

mrexcel [dot] com/forum

[crnadak87]

@ExcelIsFun Just as I taught. Thanks

[ExcelIsFun]

@AMR421RA , You are welcome!

[AMR421RA]

@ExcelIsFun Thank you I found this out after I wrote this comment. Thanks for the reply back. This helped me out with a project I had for work.

[ExcelIsFun]

@AMR421RA , try:

=MOD(8:00 AM - 11:00 PM,1)

Here is two videos:

Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

Excel Magic Trick 501: Excel Time Format & Calculations (10 Examples)

[AMR421RA]

@ExcelIsFun What if you were going to calculate the the total hours for a worker who worked a 3rd shift schedule (e.g. 11:00 pm to 8:00 am). This formula wouldn't work for this example. Can you please tell me how I would do this for a 3rd shift worker?

[MrAAAAA1982]

Your Videos are so coooooooooooooool man..

Thanks for all of that.

[1231234akm]

can you help me