time conversion

  • Thread starter Thread starter Andrew Richards
  • Start date Start date
A

Andrew Richards

Would I be able to ask for assistanse please?

How am I able to convert Time(UTC) into time for our timezone ,which is GMT
+ 10 hrs?

Thanks in advance
--
Kind regards,

Andrew Richards

Henderson Seed Group Pty.,Ltd
C/- Plant Industries Building
School of Agriculture and Horticulture
University of Queensland
Gatton, Qld., 4343

phone : +61 (07) 54 601088
fax : +61 (07) 54601087
email : arichards(at)mailbox.uq.edu.au
 
Thanks so far - Another Question
The data download from our weatherstation is in a .csv file as these times
& I am having difficulty converting to a time format to start with.
Regards Andrew Richards

2400
100
200
300
400
500
600
700
800
900
1000
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
2200
2300
 
Since XL stores times as fractional days, you'll need to divide the
hours by 24. One way:

A2: 100
B2: =A2/2400

Format column B as time (Format/Cells/Number/Custom [h]:mm)

You could do this in place by putting 2400 in a cell, Copy the cell,
select your times and choose Edit/Paste Special, selecting the
Values and Divide radio buttons. Format as above.

This macro will convert any cells selected:

Public Sub ConvertHundredHours()
Dim cell As Range
For Each cell In Selection
With cell
If IsNumeric(.Value) Then
.Value = .Value / 2400
.NumberFormat = "[h]:mm"
End If
End With
Next cell
End Sub
 
If you mean that 1100 = 11:00

=TIME(int(A1/100),mod(A1,100),0)

Will convert to time values for you.
 
Back
Top