Simple Date problem -_- Please Help !

  • Thread starter Thread starter James8309
  • Start date Start date
J

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 :D
 
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
 
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?
Click to expand...

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