Splitting time into hour, mins,secs

[nightracer]

Hi

Can anyone help me to split time!!

I have in cell a1 a 24 hour time i.e. 21:33:27

What i would like to do is split this out so that cell b1=hours (21), c1=mins(33) and d1=secs (27)

I'm hoping ther's a really easy formula to do this?

Thanks

 

[Greg Truby]

<ul>[*]=Hour(A1)[*]=Minute(A1)[*]=Second(A1)[/list]

 

[nightracer]

Thanks Greg, that's great, can the second part be used to include hundredths of seconds?

21:33:27.68

Then =Second(A1) to show 27.68?

 

[Greg Truby]

=A1-TIME(B1,C1,0)

Set number format to ss.00

 

[nightracer]

Ah, you simply subtract the hours and minutes, thank you once agin Greg