Custom Time Function (MS XL97-2002)

Topic

New Reply

I have a users that import data from another application in plain minutes (no decimal parts).
I need to convert those into hours and minutes. Although I can do this with formulae for each entry, I imagine that I need to create a simple (?) function could be run by code that inserted a new column and put the hours and minutes (hh:mm) as a conversion of the number of minutes beside it.
The bit I can’t fathom is how to get XL to realise it has nothing to do with dates and is simply a conversion of minutes to hours and minutes.
Any suggestions would be appreciated.
Thanks

Reply | Quote

Replies

Assuming that the minutes are imported as just numbers, the following formula should work if such a number is A1 (the result shoul be formatted as h:mm :-

        =TIMEVALUE(INT(A1/60)&":"&MOD(A1,60))

Hope it helps

Andrew C

Reply | Quote

Thanks Andrew.

I wasn’t on the right path but that is just what I needed.

Leigh

Reply | Quote