Show current UTC time in a spreadsheet

$2-3 USD / hour

Closed

Posted

over 2 years ago

$2-3 USD / hour

This task pays $2 total for the first person with a solution that I have successfully tested. How do I get the UTC time in cell B5 (shaded in yellow), to represent itself correctly regardless of the time zone of the viewer? The unprotected cells are all editable here for testing. https://docs.google.com/spreadsheets/d/1vL0bnZt2ukpM9dZpAEdSB8UTOKF1d2DzRWhfumFF4eA/edit#gid=352989457 Assistance is greatly appreciated.

Project ID: 31805676

About the project

9 proposals

Remote project

Active 2 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

9 freelancers are bidding on average $9 USD/hour for this job

@osamawebjuggler

Hi I am expert in excel having experiance in excel and work with 100% accuracy and quality.,,,,,,,,,,,,,,,,,,,,,,,,,,

$2 USD in 40 days

5.0

(37 reviews)

5.0

@enywindows

Hello client, I have read your project and i can create a formula for the cell that would allow it show the correct time by relating it to a standard time. Kindly chat me up as i can offer the solution many more. Thanks

$2 USD in 40 days

5.0

(1 review)

1.5

@baloguntemitope2

Hello client I can help you or assist you on the right tools for your project. I can help you get the UTC time in excel perfectly well. I am ready to solve the problem now within your budget. Thanks.

$3 USD in 40 days

0.0

(0 reviews)

0.0

@LinaOsman

Hello there I'm a talented and very hard worker and also know the value of time. My motivation is to make my employees feel satisfied with the result, so I hope to work with you.

$3 USD in 40 days