Convert timevalue to text

A simple way is to just add TODAY() to the decimal time value and format the cell to display as you want.

SG

Hi drmelzie,

TIMEVALUE() is designed to return a number. It is a way of striping a number out of a date/time value.

It would help to understand why you are using TIMEVALUE() to begin with. What are you inputs?

quinn

drmelzie wrote:

I exported to Excel and was able to format the decimal number as hh:mm:ss without having to add TODAY()+ to the formula.

Yes, handling of date and time is one area where Excel and Numbers differ. Numbers always treats a time or date in a cell as a date-time string. If you format it as "just a date" the time part is still there. And vice versa.

In Numbers using TODAY() results in a date-time string that is today's date with a time of 00:00:00. When you add the decimal time value to that date-time string you get a new date-time string, which you can then format to show either the date or the time, or both.

Numbers has the concept of "duration" values in cells, which can be very handy. Check out the DURATION() function in Numbers, which a completely different animal from the Excel DURATION() that relates to bonds, plus DUR2DAYS(), DUR2HOURS() and other related functions. Using durations in Numbers can simplify date-time math. For examples examples of how durations can be used in formulas see the Calendar and Employee Schedule templates at File > New in your menu.

SG

you should generally describe WHAT you want to do (omitting the how). specifying timevalue or any other function right now is the HOW. Focus on sharing what you want to do and let us assist you.