• I do not know how your table looks like specifically , however you can use date-functions to extra for example a timestamp. If you have a start time and an endtime you could subtract these two from eachother.

Functions you could use:

• GETYEAR(datetime)
• GETQUARTER(datetime)
• GETMONTH(datetime)
• GETDAY(datetime)
• GETHOUR(datetime)
• GETMINUTE(datetime)
• GETSECOND(datetime)

• You could also use the time difference functions,

YEARDIFF(end,start)

QUARTERDIFF(end,start)

MONTHDIFF(end,start)

DAYDIFF(end,start)

HOURDIFF(end,start)

MINUTEDIFF(end,start)

SECONDDIFF(end,start)

If you have only the beginning time stamp, and you want to see how much time passed since then, you could utilize the now() function:

DAYDIFF(now(),[timestamp])

LMK if you'd like any further assistance here,

ido.darnell@qbeeq.pl

qbeeq.pl

• Rereading here, if you have the date in one column and the timestamp in another, you will need to merge them into a date-time format, so you will need to use the add-time functions as Hamza stated above to merge them into a single column,

Thanks Hamza, looking forward to speaking!

Ido

• Thanks for the info Ido and Hamza.

I have here is only a timestamp column. I only used the count(hours in timestamp) and I was able to count the total hours spent by employee in a month. But I can't get the correct percentage on each activity. (i'm using pivot on this which in rows I have the name of the employees and the activities -- in column part is the months Jan-Dec )

Result I want to achieve is the percentage of the time spent doing each activities.

For example the total hrs in the month of January of employee A is 26 hrs

Time spent in activity  A = 5 hrs = 19.23 %

Time spent in activity B = 10 hrs = 38.46%

Time spent  in activity C = 11 hrs = 42.30%

This is the result I want to achieve.

• Hi,

You could use the 'Contribution' quick function:

https://documentation.sisense.com/latest/creating-dashboards/using-formulas/quick-functions.htm

That should achieve that result