Kelsey
To enter dates and times without using a separator you would need VBA code.
See Chip Pearson's site......
http://www.cpearson.com/excel/DateTimeEntry.htm
Also see his site for Time Arithmetic
http://www.cpearson.com/excel/datetime.htm#AddingTimes
Gord Dibben Excel MVP
On Sat, 22 Jan 2005 12:43:02 -0800, "KELSEY1022"
wrote:
I would like to use Excel to calculate total minutes between two times,
without using the colon sign (it would be so much faster). 1315 to 1525
would be 130" not 210.