ExcelBanter - Convert HH:MM to number as minutes only

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Convert HH:MM to number as minutes only (https://www.excelbanter.com/excel-discussion-misc-queries/92151-convert-hh-mm-number-minutes-only.html)

Blurb

Convert HH:MM to number as minutes only

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.

Max

Convert HH:MM to number as minutes only

"Blurb" wrote:
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.

With source in A1, try in B1: =A1*24*60
Format B1 as general or number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Max

Convert HH:MM to number as minutes only

"Blurb" wrote:
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.

With source in A1,
Try in B1: =A1*24*60
Format B1 as general or number
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

All times are GMT +1. The time now is 02:50 PM.