Ask Your Question
0

Can 'components' within a cell, [hr:min frmt], be accessed?

asked 2016-06-28 17:17:37 +0200

abi gravatar image

to CONVERT hr:min --> dec.Time?

Thank you ... gripWIN@gmail.com

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-06-30 17:58:30 +0200

mark_t gravatar image

You could use worksheet functions to get part of the time, example "=HOUR(A1)" if A1 contains a time.

You could also use "=A1 * 24", and format the destination cell as a number.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-06-28 17:17:37 +0200

Seen: 37 times

Last updated: Jun 30 '16