VBA Userform "CDate" calculations on Times = Total Hrs

[Kitsa]

Hi Guys,
I have a formula in my UserForm that give me h:mm, but the problem is I have staff that start at e.g. 09:00am and finishes at 02:00am, this formula I have give me return 7:00 hrs, when the return should be 17:00hrs. Does anyone know how to fix this?

Cross posted at https://www.mrexcel.com/board/thread...l-hrs.1150373/ --6SJ

[Keebellah]

Hi,
When the time spans the midnight hout, you will have to do two calculations:

one from 23:59:59 - 09:00:00 and add the value from 00:00:00 + 02:00:00

[Kitsa]

Thanks Keebellah,
I'm not that good with VBA, How would I code this?

[Keebellah]

I will need to see how you've filled the values in the textboxes.
And when you show a vba example you expect others to assume that you do know something
I'll put it together and update

[Kitsa]

My Apologise,
Doe this help?

Please Login or Register  to view this content.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

(Note: this requirement is not optional. No help to be offered until the link is provided. If you do not have permission to post the link, PM me.)

[Keebellah]

Try this, paste this code in your Userform module

Please Login or Register  to view this content.

[Keebellah]

Hi, Sorry was typing my answer and didn't see your posting about the cross-posting. until after

[Kitsa]

Hi 6StringJazzer,
I'm sorry, I wasn't aware I was allowed to do this, I'm only new at this. I would share the link but it's won't let me. You ask to PM you, what does PM mean?

[6StringJazzer]

I'm sorry, I wasn't aware I was allowed to do this, I'm only new at this. I would share the link but it's won't let me. You ask to PM you, what does PM mean?

I edited your first post to add the link for you.

PM means Private Message. To PM someone click on their name and then select Private Message from the pop-up window.

When you join any online forum, the first thing you should do is get familiar with their rules. Please take two minutes to review our rules. There aren't many, and they are all important.

[Kitsa]

Thanks and apologise again.

[Keebellah]

Just in case the code did not come throufg:

Please Login or Register  to view this content.

[Kitsa]

Hi Keebellah,
It came through and worked for me, but I would like it to come up 24:00 if I put start date 09:00AM to 09:00AM, at the moment it comes up 00:00. How can I do that?

[Kitsa]

Thank you everyone for helping. This is now solved. How do I mark this thread as solved?

[6StringJazzer]

If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon addreputationiconsmall.jpg below their name.

[Keebellah]

Hi Keebellah,
It came through and worked for me, but I would like it to come up 24:00 if I put start date 09:00AM to 09:00AM, at the moment it comes up 00:00. How can I do that?

Did you see my last post/answer?