NOTE: Someone who opens the worksheet in six months will see her own current date and time in this field, not the date and time that you saved the workbook. Use this function when you need an always-updated current time in your calculations. Whenever you recalculate (or whenever Excel recalculates automatically because other cells have changed), the function pulls the time as of that moment. Regardless of how you format the display, however, the underlying value remains constant until you recalculate. If you want only the time and not the date, you can either format it as a time and pretend the date doesn’t exist, or you can use “=NOW()-TODAY()”, which subtracts the date portion and leaves only the time portion. You can reformat the result by right-clicking the cell, choosing “Format Cells,” and picking a different time format. NOW() returns the current date and time from your computer.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |