Simple Date problem -_- Please Help !

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

James8309 - 21 May 2008 14:03 GMT

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

Reply to this Message

Bob I - 21 May 2008 14:32 GMT

format cell as [mm] and use

=A1-TIME(9,0,0)

> Hi everyone,
>
[quoted text clipped - 10 lines]
>
> Please help! Thanks alot :D

Reply to this Message

Pete_UK - 21 May 2008 14:33 GMT

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

> Hi everyone,
>
[quoted text clipped - 10 lines]
>
> Please help! Thanks alot :D

Reply to this Message

Mais qui est Paul - 21 May 2008 15:58 GMT

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

> Hi everyone,
>
[quoted text clipped - 8 lines]
>
> What kind of function do I need to use?

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

Signature

--
@+
;o)))

Reply to this Message

James8309 - 21 May 2008 23:50 GMT

> Bonsour® James8309 avec ferveur ;o))) vous nous disiez :
>
[quoted text clipped - 18 lines]
> @+
> ;o)))

Thanks everyone!!! :D

Reply to this Message