Home & Garden0 min ago
Entering Time (Duration) In Excel Spreadsheets
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)?
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)?
Answers
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
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.
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.
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.