S
spike
HEY,
DOES ANYONE KNOW HOW TO SET A FORMULA TO CALCULATE THE
MINUTES FROM TWO TIME?
THANKS,
SPIKE
DOES ANYONE KNOW HOW TO SET A FORMULA TO CALCULATE THE
MINUTES FROM TWO TIME?
THANKS,
SPIKE
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
Hi
not really sure what you're looking for?
maybe the function MINUTE is working for you. e.g.
=MINUTE(A1)
not really sure what you're looking for?
maybe the function MINUTE is working for you. e.g.
=MINUTE(A1)
N
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
M
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
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