Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to calculate the number of minutes between two times that may be on different days. So if one is 23:30 last night, and the other is 1:30 this morning, the calculation's result needs to be: 120 minutes.
I am getting one DateTime value from SQL Server (YYYY/MM/DD hh:ss) and one from Excel.I need a way to do one of the following:
Thank you!!
Hi Margaret, Timestamp# can be used to convert date formats,
Timestamp#(FieldInOtherFormat, 'MM/DD/YYYY hh:mm') // returns the timestamp in the document format
To get the difference in minutes you can substrat one date to another and multiply the result by 1440 (minutes in a day):
(EndDateTime-StartDateTime) * 1440 as MinutesDifference