Hi,
Our IT dept can't fix this on the database (Lotus Notes 6.5 accessed via ODBC) for me at the moment, & the job is quite urgent, so need a work around for poor data entry.
I'm using this formula
numberVar dur:= datediff("s",{@ShiftEnd},{@ShiftStart});//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
And @ShiftEnd & @ShiftStart follow the format of
CDateTime({Shift.ShiftDate}&" "&{Shift.ShiftTo})
Unfortunately, it keeps thorwing up an "Invalid Time Value" error >:-<. Can I do this formula just using the times? The start & end are on the same day.
All help gratefully recieved.
Cheers Alex
Our IT dept can't fix this on the database (Lotus Notes 6.5 accessed via ODBC) for me at the moment, & the job is quite urgent, so need a work around for poor data entry.
I'm using this formula
numberVar dur:= datediff("s",{@ShiftEnd},{@ShiftStart});//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
And @ShiftEnd & @ShiftStart follow the format of
CDateTime({Shift.ShiftDate}&" "&{Shift.ShiftTo})
Unfortunately, it keeps thorwing up an "Invalid Time Value" error >:-<. Can I do this formula just using the times? The start & end are on the same day.
All help gratefully recieved.
Cheers Alex