All Questions
4
questions
0
votes
1
answer
1k
views
Removing date from datetime (VBA Excel)
I need to delete the date from mulitple rows with a datetime value. Or extract the time to another cell.
For example:
A1 = 3/11/2022 10:20:00
A1 after macro = 10:20:00
or
A1 = 3/11/2022 10:20:00
A2 = ...
0
votes
1
answer
2k
views
Excel Date Timezone Conversion [duplicate]
I have a spreadsheet from a system that outputs the date and time format like this:
15/09/2021 04:29 AM
The format of the field/cell is Custom:
dd/mm/yyyy hh:mm
How do I convert the output so that ...
0
votes
5
answers
21k
views
Excel VBA or Formula to convert text to Date with Time type
I have a quite a number of data where its date/timestamp has been imported into excel as text. Excel does not really recognize it as date with time. e.g. 25.08.2011 16:17:59 (mm.dd.yyyy hh:mm:ss)
...
0
votes
2
answers
1k
views
Excel VBA Right Function Error
I'm trying to automatically update the date range on the top of my report in Excel based on the date range from data I download from a text database. In the below listed macro I get a Run-time error '...