Problems with the Time Format

[Michael Walsh]

I would be very grateful if anyone could help me with a problem that I'm
having converting to Time Format.

My boss has put together a very large timetable which details drivers'
deliveries to over 500 City Council sites. Unfortunately, he has entered
the times in default (general) format and using the decimal point to
seperate the hours and minutes instead of a colon. He has also used the
12-hour clock. The timetable is virtually useless as it stands, so I need
to change the format from general format to 24-hour hh:mm format. The only
method I can think of is very, very laborious. Is there a quick way?

Many thanks.
Mick

 

[Bob Phillips]

Mick,

Add this formula in an adjacent column, B1 say

=TIME(INT(A1),(A1-INT(A1))*100,0)

and copy down.

You will then have real time that yhou can work with.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Michael Walsh]

I'll try that Bob.

Thanks very much and thanks for replying so promptly.

I'm really jealous of your view.

I don't know how you can drag your attention from it to answer queries like
mine.

Mick

 

[Bob Phillips]

It's dark now Mick!

Bob

I'll try that Bob.

Thanks very much and thanks for replying so promptly.

I'm really jealous of your view.

I don't know how you can drag your attention from it to answer queries like
mine.

Mick