Simple Date problem -_- Please Help !

[James8309]

Hi everyone,

I have list of times in hh:mm format from cell A1 to A730

e.g. 9:30, 13:00, 13:32, 12:12 etc...

How do I put number of minutes passed from 9:00AM

i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2
displays 312 and so on.

What kind of function do I need to use?


Please help! Thanks alot

 

[Bob I]

format cell as [mm] and use

=A1-TIME(9,0,0)

 

[Pete_UK]

Put this in B1:

=A1 - 9/24

and apply a custom format of [mm]

Then copy it down your 730 rows.

Hope this helps.

Pete

 

[Mais qui est Paul]

Bonsour® James8309 avec ferveur ;o))) vous nous disiez :

Hi everyone,

I have list of times in hh:mm format from cell A1 to A730

e.g. 9:30, 13:00, 13:32, 12:12 etc...

How do I put number of minutes passed from 9:00AM

i.e. if A1 has 9:30 then B1 must display 30, if A2 has 14:12 then B2
displays 312 and so on.

What kind of function do I need to use?

=(A1-"9:00 AM")/"0:1"
number format

 

[James8309]

Bonsour® James8309  avec ferveur  ;o))) vous nous disiez :







=(A1-"9:00 AM")/"0:1"
number format

Thanks everyone!!!