View Single Post
  #3   Report Post  
Gord Dibben
 
Posts: n/a
Default

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.