Times and Minutes please help

K

knigh7s

Hello, this is what i need help with,

First Time, Last Time, Minutes between Cell one and Cell Two

0930, 1030, 60 mi
 
E

Earl Kiosterud

knigh7s,

You must enter these as real time values. Type 9:30, 10:30, etc. Now if
they're in A2 and B2, in another cell (like C2), put = B2 - A2. It will
format itself for time, and you'll be good to go. 60 minutes will show as
1:00.

If you need to see that as 60 minutes, change the formatting (Format -
Cells - Number - Custom) to:
[mm]

If you've already typed them in the plain number style, 0930, 1030, etc., it
will take some jumping through hoops to get this done.
 
K

knigh7s

Thank you for your help, it worked the way you had told me, just wish
was able to put in times (i.e. 1900,2200) as in military time :( mak
things faster, having to input over 100 times a day :(
 
E

Earl Kiosterud

k,

The formulas could be modified to allow you to enter times in that fashion
(without the colon). How would you indicate AM or PM?
 
Top