Time & Date Functions

[smokedsalomon]

I am trying to process information from a data logger.

It records the date, time and corresponding flow velocity

Cells in Column A are formatted in mm/dd/yyyy hh:mm
Cells in Column B are formatted as Numbers.

Is there a method of subtracting 1 date/time cell from another to return a value in minutes? For example:

A1 = 03/01/2011 00:00
A33 =05/01/2011 00:00
(I would hope the answer would be 89280 minutes)

There does not seem to be a direct function to carry this operation out.

Any ideas/suggestions would be most welcome

Thank You

 

[p45cal]

Either:
=(A33-A1)*60*24
formatted as General or a number
or:
=A33-A1
custom formatted as [mm]
but the latter's value hiding behind that format will be a number of days.

I got 87840 (61 days) rather than 62 days

 

[smokedsalomon]

Thank you very much! Cant believe its that simple!