Hours and minutes
If you want the results to display like 2 Hours and 15 minutes then you have
to enter the number as time not straight numbers. Format the input cells to
a time format. Enter minutes as 0:15 or hours and minutes to 2:15 (2 hours
and 15 minutes). Then sum the time and format the formula cell also to time.
"Eán" wrote:
currently the numbers are entered as numbers. i.e. 15+30+90 etc.
"Joel" wrote:
It depends how your numbers are entered. Is 15mins a number or a text
string? I have a UDF that can add strings I can modify it to return a time.
"Eán" wrote:
If I want to record time spent is there a function I can use to add time,
that is for example:
15mins + 30mins + 90mins = 2hrs 15mins or 135mins.
Please and thank you
|