I'm trying to setup a formula that will convert a number like: 75618.2154 into:
# years, remainder # months, remainder # days, remainder # hours, remainder #minutes, remainder #seconds
I've been working with some code that i found online that effective broke my number into years, months days, but did not calculate hours minutes seconds. I tried to modify it as best I could based on the logic in the formula, but I'm getting an error message that says that I've entered too few arguments for this function. Does anyone know what I've done wrong? Or does anyone know an easier way of going about this?
Thanks!
Bookmarks