on 10-27-2016 8:43 AM
Hi All,
I have a time fields like this email sent time 1:11:00 AM and call time 1:33:32PM.
I need subtract call time from email sent time .I did like this but getting numbers.
email sent time-call time
Please help
Hi Prasad,
If you need the difference in hh:mm:ss format, use this code:
NumberVar TotalSec := {email sent time} - {call time};
NumberVar Hours := Truncate (Remainder (TotalSec, 86400) / 3600);
NumberVar Minutes := Truncate (Remainder (TotalSec, 3600) / 60);
NumberVar Seconds := Remainder (TotalSec, 60);
(If Hours > 1 then Totext(Hours,0,'') & " Hours " else if Hours = 1 then Totext(Hours,0,'') & " Hour " else "")&
(If Minutes IN [0.1 to 1] OR Minutes > 1 then Totext(Minutes,0,'') & " Minutes " else if Minutes = 1 then Totext(Minutes,0,'') & " Minute " else "");
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prasad,
The number you are getting is the seconds between your times. So take that number and divide by 60 and you will get the number of minutes.
Your formula should look like:
({table.email sent} - {table.call time}) / 60;
This will give you 697.47 minutes.
(({table.email sent} - {table.call time}) / 60) / 60;
or
(({table.email sent} - {table.call time}) / 3600);
Will give you 11.62 hours.
Thanks,
Brian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.