convert decimal input to real time vba code

aboly8000

Board Regular
Joined
Sep 4, 2019
Messages
59
Hi
I need a vba code that converts a decimal input to real time and does nothing if it's time.
for example:
2.5 convert to 2:30
3.5 convert to 3:30
and if input is time do notting
2:30 convert to 2:30
3:30 convert to 3:30
.
.
.
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Unfortunately, there is not.

The simple solution is to change the user, not the code. Enter all times in a consistent format and your problem is solved.
Then introduce a code that accepts only time as input(Error message for decimal and text input(
 
Upvote 0
Times are decimals, so that is not possible either.

12:00 = 0.5 days, 3.5 days = 84:00 hours, there is no way to identify which was entered.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,937
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top