Back in July I posted VBA to set a Name variable to the local UTC offset, and quickly got a reply from @Domenic with a link to Get Timezone Information in VBA (Excel). I posted the code I developed to set a Defined Name to the UTC value in hours. It works fine, and I was thinking about adding...
Hi,
I am using the gauge visualizations to show the sales versus target for the present day and another one for yesterday.
The date is filtered via relative date.
However I must wait for 08:00 in the morning for that specific visualization to update to the current local time.
This is logical...
I am having difficulty with converting a cell with UTC time
<tbody>
2017-08-11T06:15:19.711Z
to PST time
</tbody>
Using Office Pro Plus 2016 Excel 2016 MSO (16.0.4849.1000) 32 Bit
<tbody>
a
b
c
d
e
1
User ID
Login
UTC
Users
2
1
Yes
No
1
3
1
Yes
No
1
4
1
No
No
1
5
2
No
Yes
1
6
3
Yes
Yes
1
7
4
Yes
No
1
8
4
No
No
1
9
5
No
No
1
</tbody>
What I need to try and work out is as follows as a formula for Column D is a follows :-
Colums C is to ="No"...
I have multiple tabs in a workbook all with the same type of data but for different weeks. I need a macro to insert a column at the beginning of the data and create a column A with the heading "Week" that will fill in the whole column down to the last row with data with the worksheet name. It...
I'm getting some time & date values in the UTC time - they look like this yyyy-mm-dd HH:mm:ss:fff UTC, e.g.:
2018-07-13 10:01:11.427 UTC
2018-07-13 10:01:10.612 UTC
2018-07-13 10:01:03.931 UTC
2018-07-13 10:00:58.201 UTC
2018-07-13 10:00:55.298 UTCI'm using text to columns to cut off the UTC...
Hi All,
I've the below code but it doesn't seem to convert the 0 to show UTC
however the second to last line where the numbers are formatted works for all possitive and negatives but not for 0.
Format(ComboBox1.List(i), "+h:mm;-h:mm; ""UTC"" ")
I've tried all sorts of combinations, many...
Hi All,
I am trying to figure out how to use a script to transform the following data into fields/columns with their associated values. Each file has a varying amount of sub-data under it, each delineated by some number of dashes (e.g. "-----------" or "------------------------------"). For...
I have a spreadsheet with 4000+ lines of data and i wish to display uk gmt time in cell a1 and utc in cell b1. Could someone please give me the correct formulas for each cell?
Hello Again Mr and Mrs Excel,
I had columns with Headings:
Local Date, Local Time, UTC Date and UTC Time and a lot more columns to the right which I am not really concerned about.
With a command button pressed, all the columns in a single row are filled from corresponding Textboxes in...
Hello all,
I apologise if this is a duplicate - I tried to post it earlier but couldn't see it anywhere.
I have written a module to convert date & times provided in UTC time into a different local time zone.
The coding works well and automatically takes into account nay daylight saving time...
Hello all,
I'm writing a module to convert date & time provided in UTC format, into a local time zone of my choice.
The code works fine in converting to the required time zone, but I want to them place a formatting over the top to indicate which time zone it relates to.
I do not want to add...
Hello Excel experts,
I want to convert between the time in my timezone and UTC time by using some functions. I don't need a date part, but only need a time. Through some research on the internet, I found and modified codes that works, but with some errors.
1. For function "ConvertLocalToGMT"...
Should be simple.... I need to say for all rows that have data in them from end up, put this formula =I1-(5/24) in column J. Adjusting the I# for each row.
I am subtracting 5 hours from the time, and need to use this formula to maintain the structure of the other data in the cells.
Cells...
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.