Ask Your Question

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 ...

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

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


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

Seen: 46 times

Last updated: Jun 30 '16