convert date format from weeks.days to format excel can read

0

Hello,

I am trying to get the average length of time for dates that are stored in excel as weeks.days

For example, 36 weeks 6 days is entered as 36.6

As you can see, this is a problem for finding the average! Is there a way to convert 36.6 into 36.86 (because 6 days is 86% of a week), so that I can find an actual average length of time?

Answer
Discuss

Answers

0
=TRUNC(A1)+RIGHT(A1)/7

Works for cell A1, change the cell reference as needed.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login