Converting durations to minutes

[NewOrderFac33]

Good morning,

I have a series of time values which are formatted thus e.g. 28hr 46m 22s

I have some code that builds up a string containing the "minute" vales of these strings, so, for example 10h 15m 17s would display as 615 (10*60+15)

I achieve this with:

MinuteValue = (Hour(Selection) * 60) + Minute(Selection)

This works fine as long as the value doesn't exceed 24 hours - 28hr 46m 22s for example returns 286 when it should be 1726 (28*60)+46
Do any of you nice folk have a suggestion as to how I can alter my code to include up the days correctly?

Thanks in advance

Pete

 

[jmacleary]

Hi there. Try: MinuteValue = Round(MySelection * 60 * 24, 0) (I have changed the name you used as it is a word used in Excel and I always try to avoid using names like that).

 

[NewOrderFac33]

John - perfect! I was only using "Selection" whilst I was testing the code manually on selected cells, but thanks for the spot nevertheless!
Pete

 

[jmacleary]

You're welcome and thanks for the feedback (I was very lazy and didn't use code tags - naughty!

 

[NewOrderFac33]

I think for one line of code you can be forgiven!