How to work with time values in SAC ?

[former_member1058235]

I've been trying to visualize employee time sheets with employee's duty in and out times formatted as 'hhmmss' (in excel) to find out employee's average duty in and out times in SAC however it doesn't seem like SAP analytics cloud supports visualization of time values. Please correct me if I am wrong.

[former_member785401]

Hello Haroon Azhar,

While importing your excel in SAC, you have the option to change the type of the field. There you can find a type named Timestamp. You can use this type for your In-Time and Out-Time but the format should be something like this. It comes along with the date.

Hope this helps you !

[former_member1058235]

Hi Hariesh,

Appreciate your response; I had tried this already but this doesn't work. Still not able to measure and visualize average times.

Regards
Haroon