Percent of work day

[cthorne1]

Hey! So if I have the time my work day begins and ends, and the current time in an excel file, can I get what percent of the way through the day the current time is?
So like if
A1= 9:00 AM
A2= 5:00 PM
A3= 1:00 PM
then have A4= 50%
Is there anyway to do this?

 

[6StringJazzer]

In A4:

=(A3-A1)/(A2-A1)

Format as %

(This will not work if your work day starts before midnight and finishes after midnight. Need to enhance for that case.)

 

[cthorne1]

So when I do this I am returning a value of 10397261%. If my A3 is set to =NOW() instead of a manually typed in time will that effect how it is calculated?

 

[HongRu]

So when I do this I am returning a value of 10397261%. If my A3 is set to =NOW() instead of a manually typed in time will that effect how it is calculated?

A3
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))

 

[cthorne1]

A3
=TIME(HOUR(NOW()),MINUTE(NOW()),SECOND(NOW()))

Oh, perfect! Thank you so much!!

 

[6StringJazzer]

NOW gives you the date and time. You need just the time. This strips off the date:

=MOD(NOW(),1)