How to calculate percentage of given time

[vishwanathkumar.s]

Hi All,


I am working as an Analyst in BPO company. I have strucked with break calculation.

My question is:


I need one calculator, which calculates the 13% of break time, based on employees total login hours.


My condition is: employee should enter the time, when logs in to the system and remaining should be calculated automatically and this timer should run for entire shift.


In my point of view formula should be as below:


System time - Login time = Login Hours

Login Hours*13%


Timer should keep running


Please reply.......


Regards,


Vishwanath Kumar .S

 

[Hui]

Vishwanath

You can use the following

assuming you type your start time in B4 in the format HH:MM:SS am/pm


=TEXT(((NOW()-INT(NOW()))-B4)*0.13,"h:mm:ss")


press F9 every now and then to recalculate

It will show you the time difference x 13% in Hrs:Min:Sec

 

[vishwanathkumar.s]

Hey,


This is awesome....


Thanks a ton........


Regards,


Vishwa