formatting problem

  • Thread starter Thread starter Orion
  • Start date Start date
O

Orion

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
 
Thanks Rob, I tried <mm> instead of <[mm]>




Custom Cell Format
[mm]
or
[mm]:ss
Click to expand...



Orion said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel formula 1
Excel =SUM(A1=A1+B1) 0
Rolling Total 6
userform exception error 4 textboxes 7
Copying Sheet1 to Sheet2 in a certain pattern 6
Sum number range ignoring numbers formatted as text 0
linkable cell like result of a formula 4
Problem Applying Formula to cell 2

Back
Top