Convert HH:MM to number as minutes only

B

Blurb

I am looking for a formula to changed formated cells as HH:MM to a whole
number of minutes only.

For example 07:20 change to 440. 440 being the number of minutes.

Thanks
in advance.
 
M

Max

Blurb said:
I am looking for a formula to changed formated cells as HH:MM to a whole
number of minutes only.
For example 07:20 change to 440. 440 being the number of minutes.
Click to expand...

With source in A1, try in B1: =A1*24*60
Format B1 as general or number
 
M

Max

Blurb said:
I am looking for a formula to changed formated cells as HH:MM to a whole
number of minutes only.

For example 07:20 change to 440. 440 being the number of minutes.
Click to expand...

With source in A1,
Try in B1: =A1*24*60
Format B1 as general or number
 
Top