Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Time calculation Post Reply Post New Topic
Author Message
refeesh
Newbie
Newbie


Joined: 09 Feb 2011
Location: Saudi Arabia
Online Status: Offline
Posts: 9
Quote refeesh Replybullet Topic: Time calculation
     Posted: 29 Feb 2012 at 8:54pm
i m facing a problem to make attendance report.
i have the date in and out. to calculate the late i want to minus the time in to 7.30am how can i do in crystal report formula
IP IP Logged
rkrowland
Senior Member
Senior Member
Avatar

Joined: 20 Dec 2011
Location: England
Online Status: Offline
Posts: 259
Quote rkrowland Replybullet Posted: 29 Feb 2012 at 10:37pm
datediff("n",#07:30:00#,{table.timefield})
 
The above formula will return the difference in minutes.
 
Regards,
Ryan.
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum