Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two fields : 1) date and time received : 12/16/2013 07:23 am
2) date and time sent : 12/17/2013 05:00 pm
No how can i find the total hours between date and time sent and date and time received.
Thanks & Regards
Jyothish KC
Sure Jagan,
This a sample of my excel sheet.
Name | Date Received | Time Received | Date sent | Time Sent |
---|---|---|---|---|
a | 17-Dec-13 | 3:44 AM | 18-Dec-13 | 2:39 PM |
b | 17-Dec-13 | 3:44 AM | 17-Dec-13 | 3:25 PM |
c | 17-Dec-13 | 3:44 AM | 23-Dec-13 | 3:25 PM |
Now i am trying to find out the time duration between both.
Hi,
Try this script
LOAD *,
IntervaL(Timestamp#([Date sent] & ' '& [Time Sent], 'D-MMM-YY HH:mm TT') - Timestamp#([Date Received] & ' '& [Time Received], 'D-MMM-YY HH:mm TT'), 'H') AS Diff
INLINE [
Name,Date Received, Time Received, Date sent, Time Sent
a, 17-Dec-13, 3:44 AM, 18-Dec-13, 2:39 PM
b, 17-Dec-13, 3:44 AM, 17-Dec-13, 3:25 PM
c, 17-Dec-13, 3:44 AM, 23-Dec-13, 3:25 PM];
Regards,
Jagan.