Four digit number /military time

[linesite]

I'm looking for a way to insert four numbers (e.g. 1830, 0830, 1215) into two cells (start /end time) without inserting a colon between the first two numbers and the second (e.g. 18:30, 08:30, 12:15) and ultimately compute the difference between the two times for the number of hours worked in a nearby cell.

Any help is greatly appreciated.

Keith

 

[VoG]

This may help http://www.cpearson.com/excel/DateTimeEntry.htm

 

[Aladin Akyurek]

I'm looking for a way to insert four numbers (e.g. 1830, 0830, 1215) into two cells (start /end time) without inserting a colon between the first two numbers and the second (e.g. 18:30, 08:30, 12:15) and ultimately compute the difference between the two times for the number of hours worked in a nearby cell.

Any help is greatly appreciated.

Keith

Assming that A2 <= B2 holds...

A2: '0830

B2: 12:15

C2:

=B2-TEXT(A2,"00\:00")

 

[scottylad2]

Excel Workbook
	G	H	I
5	Start	End	Total
6	1830	2100	3:10
7	1755	2355	6:00
8	1200	1800	6:00
Sheet1

and format as either [h]:mm or if its only for counting leave as decimals