Hi


"ims" wrote in message
...
Dear all,

2 questions please.

I have got a spreadsheet to calculate time in hours and minutes

A B C
15:00 20:15 5:15

1. When I input "15" in Cell A1, how to format to make it display
"15:00"

You can't!. Either enter 15:0, or use another column with formulas to
convert it to time [=TIME(A1,0,0)], or use worksheet's Change event to
rewrite any entry made into column A.


?

2. Cell C1=B1-A1, similarly, how should B1 & C1 be formatted?

For cell B1, look above. Format the cell C1 in any valid time format.

P.S. In case you have time intervals with midnight rollover, use formula
C1=B1-A1+(B1<A1)



--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )