![]() 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. Uses these in two sample workbooks: a timesheet calculator and a time zone converter. ![]()
0 Comments
Leave a Reply. |