calculating times

[spike]

HEY,
DOES ANYONE KNOW HOW TO SET A FORMULA TO CALCULATE THE
MINUTES FROM TWO TIME?
THANKS,
SPIKE

 

[Frank Kabel]

Hi
not really sure what you're looking for?
maybe the function MINUTE is working for you. e.g.
=MINUTE(A1)

 

[Norman Harker]

Hi Spike!

Posting in all upper case makes it more difficult to read especially
if your first language isn't the one used.

To calculate the minutes between times in A1 (earlier time) and B1
(later time)

=B1-A1
Format [mm]:ss

But if the times can span midnight:

=B1-A1+(B1<A1)
Format [mm]:ss

The (B1<A1) serves to add 1 to recognise the fact that you have gone
into a new day.

But if you include date elements in both times you can use the simple
=B1-A1 formatting [mm]:ss

Finally, if you want the results as a decimal number of minutes rather
than Excel time format you need to multiply all of the above formulas
by (24*60) and format as General.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Max]

Maybe switch off your Caps Lock?
Posting in all CAPS is considered impolite ..

ok, perhaps something like this?

Suppose you have the 2 times

in A1: 8:00
in B1: 15:00

Put in C1: =ABS(B1-A1)

Now, format C1 to show minutes:

Click Format > Cells > Number tab
Choose "Custom" under Category
Input in the box for Type: [mm]

Note: The 2 square brackets [] must be part of the input

For the sample times in A1 and B1 above,
C1 will show 420