I have a requirement which gives the sample output data like the below table (Column 1 and Column 2).
Audit Date is the Audit Date and Time spent is the Date difference from the current to the previous Audit date and the Expected output column is where we need to get from Time spent
|Audit Date||Time Spent||Expected output|
|20/8/2018 12:30||12765***||Time Difference from the Current Date to Audit date.|
What kind of formula would get the results like on the Expected Output column? The input for the column is Time Spent.