Excel/VBA/Dividing and Multiplying Time Variables

[jherbster]

I need to be able to enter a Time using hh:mm:ss format and then dividing the number by an integer. Then I need to multiply the result by another integer and express the result in hh:mm:ss format. I have tried using Date/Time variables but the division is dividing all of the days included in the entry. Any help appreciated.

[JLGWhiz]

the days value is an integer value and should be handled separeately then concatenated to the reusult of the time, which may also need to be handled separately and concatenated to put it all back together, unless you do it by the double integer value of date and time which is a decimal value.

For example with the time, say your value is in cell B2

Please Login or Register  to view this content.

Should give you a result in "00:00:00" format.

[jherbster]

Thanks. I was hoping for a less used function but i can handle what you suggested. Thanks again