utc

  1. J

    Need small fix to previous UTC post

    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...
  2. cyrilbrd

    Power BI Gauge Visualization

    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...
  3. T

    UTC to PST one cell to one cell

    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
  4. G

    Sumproduct or sum or whatever else ??

    <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"...
  5. S

    Macro to Add Column on Multiple Tabs to represent Sheet Name

    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...
  6. fraudit

    Add 1 hour to the cell

    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...
  7. S

    Combo Box Time Zone Format Values

    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...
  8. N

    VBA Script to Transform Text File Data into Fields with Values

    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...
  9. P

    GMT & UTC time ?

    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?
  10. F

    VBA to Add or Subtract Hours from the Local Date and Time

    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...
  11. well2ant

    VBA to apply custom NumberFormat for date/time time zone

    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...
  12. well2ant

    VBA to set a custom date (time zone) format

    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...
  13. M

    Convert between Local Time and UTC Time

    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"...
  14. L

    VBA for all available rows input formula in column D

    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'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