Donate SIGN UP

Entering Time (Duration) In Excel Spreadsheets

Avatar Image
joggerjayne | 14:40 Wed 28th Jan 2015 | Technology
7 Answers
Can I format an Excel cell (or column of cells) to show the duration of something?

For instance, if something takes 1hr and 15mins ...

Can I get the cell to understand that 1.15 means one hour and fifteen minutes (as opposed to 1.15 hours)?
Gravatar

Answers

1 to 7 of 7rss feed

Avatar Image
I don't think you can expect it to realise a decimal point is a divider between hours and minutes. It'd work if you put 01:15. What you can do is use multiple functions to convert the decimal fraction into minutes first.
17:22 Wed 28th Jan 2015
Yes Jayne, just go to the cell and format it as hh:mm.

Sorry, meant Custom format it.
Question Author
I've just tried that.

When I type in 1.15 ...

it shows in the cell as 03:36
I don't think you can expect it to realise a decimal point is a divider between hours and minutes. It'd work if you put 01:15.

What you can do is use multiple functions to convert the decimal fraction into minutes first.
Question Author
Ahaaaah!!

Thanks, guys.

Sorted x x
Glad that gave you a hint.

This also seems to work ok if you format it hh:mm.
=((5*60)+(15))/1440

1440 being the number of minutes in the day of course.

Substitute the 5 and 15 for functions that work out the hours and minutes from the decimal fraction value you wanted to use. Or even point them to different cells.
Question Author
whoosh !!! >>>>>>

(that was OG's last post going over my head)

1 to 7 of 7rss feed

Do you know the answer?

Entering Time (Duration) In Excel Spreadsheets

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.