Forum Discussion

FBarri's avatar
FBarri
New Member
3 years ago
Solved

Return text value based on cell time value

Hi All,  I have data of agents logging to work  ,the log in time is captured in hour, minute, seconds , I need to add a column that indicates what shift the agent was working at based on log in time...
General Comment
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi FBarri 

     

    First change the [Log in Time] column to time type. Then add a custom column with below code. 

    if [Log in Time] >= #time(7,0,0) and [Log in Time] < #time(19,0,0) then "Morning" else "Night"

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi FBarri 

 

First change the [Log in Time] column to time type. Then add a custom column with below code. 

if [Log in Time] >= #time(7,0,0) and [Log in Time] < #time(19,0,0) then "Morning" else "Night"

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.