• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Work week calculator

sheter

sheter

Member
I can't seem to figure out a clean way to calculate time. I’d like a way to have excel display what time I can go home! For example currently this week, I’ve worked 35:58 out of 40 hours. The current time is 8:41 am. Can anyone help me write something that will calculate this?


Thanks!
 
Hi ,


You need to specify the Start_Time and End_Time of your work day , since otherwise , given that the current time is 8:41 AM , you could have just come into office , or you could have already put in more than an hour of work.


Narayan
 
You must log in or register to reply here.
Back
Top