Time Calculation in Pivot

[Ratan Bhushan]

Hi Team

I have data where I have login hours of daily of emplyees.
When I use pivot to check the total login hours of all the dates, it is not showing the total hours... Please help me.
I have attached the file
Thanks
RatanB

 

[alacrity59]

In excel time is stored as the number of days. 2:32:41 is actually .106030092592593 days. So if you want the hours you need to multiply by 24. 0.106 x 24 = 2.544.

(0.544 x 60 minutes in an hour = 32.64 minutes . . . .64 minutes x 60 seconds in a minute = well not quite should have kept more decimal places . . . but you get my drift?)

 

[alacrity59]

An example based on the spreadsheet provided.

 

[Ratan Bhushan]

An example based on the spreadsheet provided.

Hi Sir

the solution you have provided me with is awesome, but, the issue I am facing is the digits after decimal does not show the exact mintues. How to achieve that this in pivot... The hours are ok now.... but how to achieve mintues... if an employee has passed only half an hour and then how we will show it.

 

[NARAYANK991]

Hi Ratan ,

You do not need to do anything , except change the cell format to :

[h]:mm:ss

Narayan

 

[Ratan Bhushan]

Hi Ratan ,

You do not need to do anything , except change the cell format to :

[h]:mm:ss

Narayan

Narayan sir

I have formatted this but having formatted this, its showng the wrong calculation. for reference take the cells which have arrows. I have attached the file.
Thanks
RatanB

 

[NARAYANK991]

Hi Ratan ,

What I meant was that no calculation is necessary ; see the attached file.

Narayan