Entering Time (Duration) In Excel Spreadsheets

[joggerjayne]

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)?

[SeaJayPea]

Yes Jayne, just go to the cell and format it as hh:mm.

[SeaJayPea]

Sorry, meant Custom format it.

[joggerjayne]

I've just tried that.

When I type in 1.15 ...

it shows in the cell as 03:36

[Old_Geezer]

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.

[joggerjayne]

Ahaaaah!!

Thanks, guys.

Sorted x x

[Old_Geezer]

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.

[joggerjayne]

whoosh !!! >>>>>>

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