Creating a formula to calculate time difference.

[Devikl]

I am having difficulties when trying to create a formula that will calculate the difference in hours-minutes-seconds. Here is the senario:

I am trying to find out the time span between an exam being dictated to transcribe.

Please help!

 

[Madawc]

DateDiff includes the ability to find the difference between two date-time values, in seconds. Once you have the value in seconds, use division and remainders to get it into minutes and hours.

I'd advise doing it step by step. Also use SEARCH to check for recent examples.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Devikl]

Hi Madawc,

Thank you very much for your fast response. I am a new user and this may be a really stupid question but here is my formula:

{v_MROTranscribed.RSD_DATE} - {v_MRODictation.RSD_DATE}

How do I use the DateDiff on this formula to get the difference in date and time?

Thank you.

 

[AndyMc]

Devikl,

DateDiff ("s", {v_MROTranscribed.RSD_DATE}, {v_MRODictation.RSD_DATE})

This returns the number of seconds as Madawc mentioned.

The thread below showed formulas to display minutes to hours and minutes:

http://www.tek-tips.com/viewthread.cfm?qid=1398725&page=1

Andy

 

[AndyMc]

Devikl,

I think you need to reverse it - 1st start date then end date:

DateDiff ("s", {v_MRODictation.RSD_DATE},{v_MROTranscribed.RSD_DATE})

Andy

 

[Devikl]

I am now able to get the time difference in seconds, how do i create the formula to translate seconds to hour,minutes and seconds?

Here is my formula:

datediff("s",{v_MRODictation.RSD_DATE},{v_MROTranscribed.RSD_DATE})

 

[lbass]

Please see faq767-3543.

-LB

 

[AndyMc]

The thread below (look to the end) shows formulas to display "minutes" to hours and minutes (this should get you in the right direction):

http://www.tek-tips.com/viewthread.cfm?qid=1398725&page=1

Andy

 

[Devikl]

I can get the time difference in hours and minutes, how can I modify my formula to show seconds as well?

Here is my formula:

numberVar dur := datediff("s",{v_MRODictation.RSD_DATE},{v_MROTranscribed.RSD_DATE}); //get the seconds between 2 dates
numberVar hrs;
numberVar min;
stringVar hhmm;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
hhmm :=totext(hrs,"00") + ":" + totext(min,"00");

hhmm

 

[AndyMc]

lbass showed where to find it a couple of messages above:

http://www.tek-tips.com/faqs.cfm?fid=3543

whileprintingrecords;
numberVar dur := datediff("s",{v_MRODictation.RSD_DATE},{v_MROTranscribed.RSD_DATE}); //get the seconds between 2 dates
numberVar hrs;
numberVar min;
numberVar sec;
stringVar hhmmss;

hrs := Truncate(Truncate(dur/60)/60);
min := Remainder(Truncate(dur/60),60);
sec := Remainder(dur,60);

hhmmss := totext(hrs,"00") + ":" + totext(min,"00") + ":" + totext(sec,"00");

hhmmss

 

[Devikl]

Thank you everyone I finally can see the results I was looking for.