[FordFasteRR]

I need to make a sheet that can calculate the total minutes from time A to time B...

IE...

time IN: 3:45 pm
time OUT: 4:30 pm

total minutes = ???

I need to get this formula working !

HELP ! ?

 

[NorthernYankee]

Here is the formula u need m8


If A2 is the start time and B2 is the end time then

=INT((B2-A2)*24) Total hours between two times
=(B2-A2)*1440 Total minutes between two times

--NY

 

[FordFasteRR]

Thanks

I had some trouble with your formulas, it gave me some strange output..

anyhow.. i found these online:

http://www.cpearson.com/excel/datearith.htm

and i was able to get everything working exactly how I needed it.

Thanks !

 

[NorthernYankee]

Kewl at least you got it working.

--NY