Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Question: I need to know the formula in Excel to calculate average days. Tracking information and need help. Ex: 30 days in April, I have a number of 72 units in database, how do I get the average? And then at the end of May, I have 90 units in database from April to the end of May. What's my average days in May? Thanks.
2 replies
by jnickens2 Accepted solution
Clarifications
by oldbaritone Accepted solution
are floating-point numbers. The integer part is the day, and the fractional (decimal) part is the time, as the fraction of 24 hours.
To get the difference between dates and times, you can subtract one from the other. If you only want the date, then truncate the values to integers before beginning.
Caution: When doing averages, remember that a "fractional day" in the system is based on a 24-hour day, NOT an 8-hour work day.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies