PPRuNe Forums - View Single Post - Easy (I think) Excel question

27th November 2009 | 13:51

#2 (permalink)

Whirlygig

Hovering AND talking

Joined: Feb 2003

Posts: 5,711

Likes: 1

From: Propping up bars in the Lands of D H Lawrence and Bishop Bonner

As long as you have the leading zero on the hh:mm format, this is will work

In the next column, put =left(A1,5) where cell A1 has the hh:mm Z. This will return hh:mm. Use copy/paste values to then convert this to a time format.

Cheers

Whirls

Reply

0