Converting 24 hr clock to GMT

R

rgullin9

I'm working with a spread sheet that we have to enter both the local
time (24 hr clock) and GMT in separate columns. I have been trying to
create a formula that when I enter the local time (24 hr clock) in one
column it automatically places the GMT in the other column. The
problem I’m having is that once the time hits a certain point it
doesn’t change over to the new time it just keeps adding up. Example:


Time
GMT Local
3200 2400



It should read:
Time
GMT Local
0800 2400
 
R

Roger Govier

Hi

It looks as if you may have your format of the cell holding GMT set to [h]:mm
Change it to h:mm with Format>Cells>Number>Custom> h:mm

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GMT/UTC considerations 9
Daily Time Sheets with Rounding 1
Function to count clock reaching 24 hours 3
Can't change back to 12 hr> clock 7
How do I display time in gmt when my system clock is set to local 3
How do i get the clock to show 24 hour time instead of 12 hour? 1
Keeping the Clock Up to Date 7
datetime conversion from UDT/GMT to localtime 5

Top