Link to home
Start Free TrialLog in
Avatar of sam2929
sam2929

asked on

get time in minutes

i want to get time in minutes

i have pdate 2011-04-21and ptime 2:38:23
then   sdate 2011-04-20 and stime 11:01:41

i want to get time in minutes between pdatetime and sdatetime
if negative values the null it

Thanks
ASKER CERTIFIED SOLUTION
Avatar of Member_2_2484401
Member_2_2484401
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Oops.

Not that it really matters much, but the label on the calcuated column should be "theMinutes", not "theHours".