Slightly strange question, but hopefully someone can help.
In essence, if the time was 12pm the the elapsed percentage would be 50%, 6am would be 25% and 16pm would be 75%.
Given the current time, how could you work out the amount of day that already passed?
By definition, percentage is a fraction or ratio expressed as part of 100. To determine the expired hours percentage, divide the expired hours of the day by the hours in the day. Decimal fractions of an hour are legitimate.
Please use this formula: =MIN(1, (DATEDIF(B2,TODAY(),"d")+1)/(DATEDIF(B2,C2,"d")+1)). It will maintain it at 100% instead of 100 over percent if today date is exceed the end date.
Assuming you can get the current time of day, it'd be pretty easy to calculate the percentage of the day elapsed.
percentage = (hours / 24 + minutes / (60 * 24)) * 100
24hours are 100% so 24/currentTime = result 100 / result = % ;)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With