Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,153
- Office Version
- 365
- 2019
- Platform
- Windows
A while ago I had gotten this formula from MarkW it works great. We get different spreadsheet in from vendors and the problem is that the time values are all formatted wrong. What I would like to get is to get all values out of decimal and into time value. If the formula for the row gives me 28.6 or 39.3 I would like to get that into a time value. Can anyone help me using the same setup below!
Thanks in advance Stephen
Thanks in advance Stephen