Time is stored as a fraction of a day
B1: ="required to have " & A1*24
"Kimti" wrote in message
...
I have h:mm format in one cell, I would like to change the format to next
cell as number but keep the number same for expample.

a b
0:21 required to have 21

Please help.