BKennedy2008
asked on
Crystal Reports convert time
Brain fried, easy one here..
If I have 5:30 in a time format in CR, result of 2 time calculations (5 hours and 30 minutes)
hour can I convert that to 5.5 in number format.
If I have 5:30 in a time format in CR, result of 2 time calculations (5 hours and 30 minutes)
hour can I convert that to 5.5 in number format.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have it:
TotalInTime:= time((NewEndTime- EditStartTime));
local numbervar NewH;
Local numbervar NewM;
NewH:=Hour(TotalInTime);
NewM:=NewH + (Minute(TotalInTime)/60);
Thanks for pointing me in the right path
TotalInTime:= time((NewEndTime- EditStartTime));
local numbervar NewH;
Local numbervar NewM;
NewH:=Hour(TotalInTime);
NewM:=NewH + (Minute(TotalInTime)/60);
Thanks for pointing me in the right path
ASKER
I am thinking maybe this...Trying it now...
Local numbervar NewH;
Local numbervar NewM;
NewH:= Hour(TotalTime);
NewM:= (minute(totalTime)/3600);
DecimalResult = HewH + NewM