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

Possible to determine whether any one instance within many satisfy a criteria? 3
Function to count clock reaching 24 hours 3
separating date and time 5
GMT/UTC considerations 9
How do i correct time zone settings? 2
24 hour time 1
24 hr time format 2
How do I display time in gmt when my system clock is set to local 3

Top