{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["NOW function - Examples","NOW function","NOW formulas","Time another day","Rounded current time","Add subtract time","Convert NOW to text","Combine text with NOW","Custom NOW fucntion","NOW with VBA"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"NOW function - Examples","index":0,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,5],[5,1,5,2]]}
[]
[]
[]
[null,"Excel NOW Function"]
[]
[null,"The workbook shows how  to use a NOW formula in Excel to insert the current date and time in the desired format. "]
[null,"Author","Ablebits.com"]
[null,"Last update","2023-01-13"]
[null,"Tutorial URL","How to use NOW function in Excel "]
[]
[null,"Examples:"]
["• ","NOW function"]
["• ","How to use NOW formula in Excel"]
["• ","Return same time in another day"]
["• "," Get current time rounded to the nearest hour"]
["• ","Add or subtract hours, minutes and seconds to current time"]
["• ","Convert NOW to text"]
["• ","Combine text with NOW function"]
["• ","Custom static NOW function"]
["• ","Insert current time as static value with VBA"]
[]
[]
[null,null,null,null,null,null," "]

{"sheet":"NOW function","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Excel NOW function"]
[]
["Current date and time"]
[{"$f":"NOW()","v":"2023-03-17T14:37:14.950"}]
[]
["Result","Formula","Description"]
[{"$f":"NOW()","v":"2023-03-17T14:37:14.950"}," =NOW()","Date and time in custom format"]
[]
[{"$f":"NOW() - TODAY()","v":"14:37:14.950"}," =NOW() - TODAY()","Time without date"]
[]
[{"$f":"MROUND(NOW(), \"1:00\")","v":45002.625}," =MROUND(NOW(), \"1:00\")","Time rounded to the nearest hour"]
[]
[{"$f":"NOW() - TIME(3, 0, 0)","v":45002.484200810184}," =NOW() - TIME(3, 0, 0)","3 hours behind"]
[]
[{"$f":"NOW() + TIME(3, 0, 0)","v":45002.734200810184}," =NOW() + TIME(3, 0, 0)","3 hours ahead"]
[]
[{"$f":"NOW()+30","v":"2023-04-16T14:37:14.950"}," =NOW()+30","30 days from now"]
[]
[{"$f":"NOW()-30","v":"2023-02-15T14:37:14.950"}," =NOW()-30","30 days before now"]
[]
[{"$f":"EDATE(NOW(), 3) + MOD(NOW(), 3)","v":"2023-06-19T14:37:14.950"}," =EDATE(NOW(),3) + MOD(NOW(),3)","Same time 3 months later"]
[]
[{"$f":"EDATE(NOW(), -3) + MOD(NOW(), 3)","v":"2022-12-19T14:37:14.950"}," =EDATE(NOW(),-3) + MOD(NOW(),3)","Same time 3 months earlier"]

{"sheet":"NOW formulas","index":2,"n_rows":36,"n_cols":18,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,5]]}
["NOW formula in Excel"]
[]
[null,"Default format"]
[null,"Result",null,"Formula",null,"Format code"]
[null,{"$f":"NOW()","v":"2023-03-17T14:37:14.950"},null," =NOW()",null,"m/d/yyyy h:mm"]
[]
[]
[null,"Custom format"]
[null,"Result",null,"Formula",null,"Format code"]
[null,{"$f":"NOW()","v":"2023-03-17T14:37:14.950"},null," =NOW()",null,"mmmm d, yyyy h:mm"]
[]
[]
[null,"Current time without date"]
[null,"Result",null,"Formula",null,"Format code"]
[null,{"$f":"NOW()","v":45002.609200810184},null," =NOW()",null,"h:mm:ss"]
[]
[]
[null,"Current date without time"]
[null,"Result",null,"Formula",null,"Format code"]
[null,{"$f":"NOW()","v":"2023-03-17T14:37:14.950"},null," =NOW()",null,"mmmm d, yyyy"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"Time another day","index":3,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Same time in another day"]
[]
["Current date and time"]
[{"$f":"NOW()","v":"2023-03-17T14:37:14.950"}]
[]
["Result","Formula","Description"]
[{"$f":"NOW()+7","v":"2023-03-24T14:37:14.950"}," =NOW()+7","Same time next week"]
[]
[{"$f":"NOW()-7","v":"2023-03-10T14:37:14.950"}," =NOW()-7","Same time last week"]
[]
[{"$f":"NOW()+30","v":"2023-04-16T14:37:14.950"}," =NOW()+30","30 days from now"]
[]
[{"$f":"NOW()-30","v":"2023-02-15T14:37:14.950"}," =NOW()-30","30 days before now"]
[]
[{"$f":"EDATE(NOW(), 3) + MOD(NOW(), 3)","v":"2023-06-19T14:37:14.950"}," =EDATE(NOW(),3) + MOD(NOW(),3)","Same time 3 months later"]
[]
[{"$f":"EDATE(NOW(), -3) + MOD(NOW(), 3)","v":"2022-12-19T14:37:14.950"}," =EDATE(NOW(),-3) + MOD(NOW(),3)","Same time 3 months earlier"]

{"sheet":"Rounded current time","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Current time rounded to nearest hour"]
[]
["Current date and time"]
[{"$f":"NOW()","v":"2023-03-17T14:37:14.950"}]
[]
["Result","Formula","Description"]
[{"$f":"MROUND(NOW(), \"1:00\")","v":"2023-03-17T15:00:00"}," =MROUND(NOW(), \"1:00\")","Current time rounded to the nearest hour"]
[]
[{"$f":"MROUND(NOW() +10, \"1:00\")","v":"2023-03-27T15:00:00"}," =MROUND(NOW() +10, \"1:00\")","Current time rounded to the nearest hour \n10 days from now"]
[]
[{"$f":"MROUND(NOW() +100, \"1:00\")","v":"2023-06-25T15:00:00"}," =MROUND(NOW() +100, \"1:00\")","Current time rounded to the nearest hour \n100 days from now"]
[]
[{"$f":"MROUND(NOW() -10, \"1:00\")","v":"2023-03-07T15:00:00"}," =MROUND(NOW() -10, \"1:00\")","Current time rounded to the nearest hour \n10 days before now"]
[]
[{"$f":"MROUND(NOW() -100, \"1:00\")","v":"2022-12-07T15:00:00"}," =MROUND(NOW() -100, \"1:00\")","Current time rounded to the nearest hour \n100 days before now"]

{"sheet":"Add subtract time","index":5,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Add / subtract hours and minutes to current time"]
[]
["Local time (UTC +3)"]
[{"$f":"NOW()","v":45002.609200810184}]
[]
["Time zone","Current time","Formula","Description"]
["Universal Time,  UTC",{"$f":"NOW()-TIME(3,0,0)","v":45002.484200810184}," =NOW()-TIME(3,0,0)","3 hours behind"]
[]
["Pacific Time, PT",{"$f":"NOW()-TIME(11,0,0)","v":45002.150867476848}," =NOW()-TIME(11,0,0)","11 hours behind"]
[]
["Mountain Time, MST",{"$f":"NOW()-TIME(10,0,0)","v":45002.19253414352}," =NOW()-TIME(10,0,0)","10 hours behind"]
[]
["Central Standard Time, CST",{"$f":"NOW()-TIME(9,0,0)","v":45002.234200810184}," =NOW()-TIME(9,0,0)","9 hours behind"]
[]
["Eastern Time, EST",{"$f":"NOW()-TIME(8,0,0)","v":45002.275867476848}," =NOW()-TIME(8,0,0)","8 hours behind"]
[]
["India Standard Time, IST",{"$f":"NOW()+TIME(2,30,0)","v":45002.713367476848}," =NOW()+TIME(2,30,0)","2.5 hours ahead"]

{"sheet":"Convert NOW to text","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Convert NOW into text"]
[]
["Result","Formula"]
[{"$f":"TEXT(NOW(), \" h:mm:ss AM/PM\")","v":" 2:37:15 PM"}," =TEXT(NOW(), \" h:mm:ss AM/PM\")"]
[]
[{"$f":"TEXT(NOW(), \"d-mmm-yyyy\")","v":"17-Mar-2023"}," =TEXT(NOW(), \"d-mmm-yyyy\")"]
[]
[{"$f":"TEXT(NOW(), \"mmmm d, yyyy h:mm AM/PM\")","v":"March 17, 2023 2:37 PM"}," =TEXT(NOW(), \"mmmm d, yyyy h:mm AM/PM\")"]
[]
[{"$f":"TEXT(NOW(), \"mmmm d, yyyy at h:mm AM/PM\")","v":"March 17, 2023 at 2:37 PM"}," =TEXT(NOW(), \"mmmm d, yyyy at h:mm AM/PM\")"]
[]
[{"$f":"TEXT(NOW(), \"dddd, d mmmm yyyy, h:mm AM/PM\")","v":"Friday, 17 March 2023, 2:37 PM"}," =TEXT(NOW(), \"dddd, d mmmm yyyy, h:mm AM/PM\")"]

{"sheet":"Combine text with NOW","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Combine text with NOW function"]
[]
["Current date and time"]
[{"$f":"NOW()","v":"2023-03-17T14:37:14.950"}]
[]
["Custom string","Formula"]
[{"$f":"\"Currently it's \"&TEXT(NOW(), \"h:mm:ss\")&\" here\"","v":"Currently it's 14:37:15 here"},"  =\"Currently it's \"&TEXT(NOW(), \"h:mm:ss\")&\" here\""]
[]
[{"$f":"CONCATENATE(\"The current time is \", TEXT(NOW(), \"h:mm:ss\"))","v":"The current time is 14:37:15"}," =CONCATENATE(\"The current time is \", TEXT(NOW(), \"h:mm:ss\"))"]
[]
[{"$f":"_xlfn.CONCAT(\"Today is \", TEXT(NOW(), \"mmmm, d, yyyy\"), CHAR(10), \"Local time is \", TEXT(NOW(), \"h:mm AM/PM\"))","v":"Today is March, 17, 2023\nLocal time is 2:37 PM"}," =CONCAT(\"Today is \", TEXT(NOW(), \"mmmm, d, yyyy\"), CHAR(10), \n\"Local time is \", TEXT(NOW(), \"h:mm AM/PM\"))"]

{"sheet":"Custom NOW fucntion","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,2],[3,1,9,1]]}
["NOW function static"]
[]
["Result","Formula","Format"]
[{"$f":"NowStatic()","v":45002.608541666668}," =NowStatic()","General"]
[]
[{"$f":"NowStatic()","v":"2023-03-17T14:36:18"},null," mmmm d, yyyy h:mm AM/PM"]
[]
[{"$f":"NowStatic()","v":"2023-03-17T14:36:18"},null," mmmm d, yyyy"]
[]
[{"$f":"NowStatic()","v":45002.608541666668},null,"h:mm:ss AM/PM"]

{"sheet":"NOW with VBA","index":9,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Insert current time with VBA"]
[]
[]
[]
[]
[]
[]
[null,null,"Current time"]
[null,null,44939.703518518516]
[]
[]
[null,"How to insert the current date and time as a static value:"]
[null,"1. Select any empty cell."]
[null,"2. Click the 'Insert time' button."]
[null,"3. Apply the desired number format to the cell."]
[]
[null,">> The instructios to create such a button are here: https://www.ablebits.com/office-addins-blog/insert-current-time-excel/#vba"]