Calculating Time

[ben_vince_uk]

I'm tring to make an XLA addin which includes a form that calculates
time.

The user will enter the total time they were working in one text box,
they will then type in the percentage of time doing a certain project
in another textbox this will then be converted to a time... Is this
possible in VBA and if so where do i start??


Formuala...

Total Time
---------- * Percentage of Time taken doing project = Time on
Project
100

Thanks for your help

Kind Regards

Ben Vince

 

[Bob Phillips]

Hi Ben,

Here is an example.

With txtProject
.Text = Format(CDate(txtTotal.Text) * txtPercentage.Text / 100,
"hh:mm:ss")
End With


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ben_vince_uk]

I'm tring to make an XLA addin which includes a form that calculates
time.

The user will enter the total time they were working in one text box,
they will then type in the percentage of time doing a certain project
in another textbox this will then be converted to a time... Is this
possible in VBA and if so where do i start??


Formuala...

Total Time
---------- * Percentage of Time taken doing project = Time on
Project
100

Thanks for your help

Kind Regards

Ben Vince

Thanks a lot Bob, thats exactly what i was after!

Regards

Ben Vince