Returning a Value in Time Format

[heresteve2]

I have a spreadsheet that I want to use the IF Function and have it return the value as a time so that the other cells that have formulas based on that output can calculate time with.

Below is the formula:
=IF(V7="","",IF(V7=319,30,IF(V7=320,40,IF(V7=321,50,""))))

Where 30,40 and 50 should be returned as 00:30, 00:40, 00:50 or even 12:30AM would work.

Thanks!

[judgeh59]

Please Login or Register  to view this content.

does that work?

[Pepe Le Mokko]

Hy perhaps use ("00:"&30)*1 to convert to time

[heresteve2]

That did the trick thanks!

[heresteve2]

Please Login or Register  to view this content.

does that work?

That worked. Thanks!

[judgeh59]

glad I could help....please don't forget to set this post to Solved....and if you believed I helped and you are so inclined to click on the Add Reputation Star, that would be great...have a great day....