Solved How to use time from a field in which Date and Time both are written.

[Khurramshaikh47]

Hi, I am using the calculation data type field in my table to make a field that can calculate grace time for employee attendance.
There are 2 different fields Time_In and Time_Out. I want to use time from the Time_In field while both time and date are written in this field. Is there a way I can use only time from this field?

Following is the syntax that I am using to calculate grace time.

IIf([Time_In]>#9:00:00 AM# And [Time_In]<=#9:15:00 AM#,(Round(([Time_In]-#9:00:00 AM#)*24,2)),0)

You Can See the situation in the screenshots below.

Thank you in Advance.

 

[June7]

Can try TimeValue([Time_In]).

 

[Khurramshaikh47]

Can try TimeValue([Time_In]).

Thank you for reply I've tried it. An errer is apparing

 

[June7]

Sorry, I did not notice trying this is table Calculated field. Use it in query or textbox.

If you want to compare just time parts, can't really include date part in parameter or need to concatenate 12/30/1899

CDate("12/30/1899 " & TimeValue([Time_In]))

 

[arnelgp]

you can also use TimeSerial():

IIf(TimeSerial(Hour([time_in]),Minute([time_in]),Second([time_in])) > #9:00:00# And TimeSerial(Hour([time_in]),Minute([time_in]),Second([time_in])) < #9:15:00#, Round((TimeSerial(Hour([time_in]),Minute([time_in]),Second([time_in])) - #9:00:00#_) * 24, 2) 0)

 

[Khurramshaikh47]

you can also use TimeSerial():

IIf(TimeSerial(Hour([time_in]),Minute([time_in]),Second([time_in])) > #9:00:00# And TimeSerial(Hour([time_in]),Minute([time_in]),Second([time_in])) < #9:15:00#, Round((TimeSerial(Hour([time_in]),Minute([time_in]),Second([time_in])) - #9:00:00#_) * 24, 2) 0)

Thank you so much arnelgp.
Solved