formatting problem
 

Hi all,

how must I format a cell which is calculating a time difference in
minutes?

eg: cell A1: start time: 12:50
cell A2: stop time: 14:50
cell A3: time to deduct [min]: 5
cell A3: time in minutes: =A2-A1-A3

which formula and what format will give me the time in minutes
in cell A3?

Thanks for any help

Regards,
Norbert

formatting problem
 

Custom Cell Format
[mm]
or
[mm]:ss

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Orion" wrote in message
...
Hi all,

how must I format a cell which is calculating a time difference in
minutes?

eg: cell A1: start time: 12:50
cell A2: stop time: 14:50
cell A3: time to deduct [min]: 5
cell A3: time in minutes: =A2-A1-A3

which formula and what format will give me the time in minutes
in cell A3?

Thanks for any help

Regards,
Norbert

formatting problem
 

Thanks Rob, I tried <mm instead of <[mm]




On Thu, 14 Oct 2004 21:16:44 +1300, "Rob van Gelder"
wrote:

Custom Cell Format
[mm]
or
[mm]:ss



"Orion" wrote in message
...
Hi all,

how must I format a cell which is calculating a time difference in
minutes?

eg: cell A1: start time: 12:50
cell A2: stop time: 14:50
cell A3: time to deduct [min]: 5
cell A3: time in minutes: =A2-A1-A3

which formula and what format will give me the time in minutes
in cell A3?

Thanks for any help

Regards,
Norbert