Working Time calculation - from text to short time

[Nancy Tang]

I would like to generate report for those who late to work. But the database
time is in text format, so i change it to short time using code as below. Is
it correct ? & how do i set a calculation for total time late in HH:MM:SS
as my working time is 09:00

Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,[dbo_Punctual.TrTime]),'Short Time') AS [TRANSACTION TIME]

 

[maheshkumargupta]

I would like to generate report for those who late to work. But the
database
time is in text format, so i change it to short time using code as below.
Is
it correct ? & how do i set a calculation for total time late in
HH:MM:SS
as my working time is 09:00

Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,[dbo_Punctual.TrTime]),'Short
Time') AS [TRANSACTION TIME]

 

[Douglas J. Steele]

Try

Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,CDate([dbo_Punctual.TrTime])),'Short
Time') AS [TRANSACTION TIME]