time deduction

C

cpliu

I can't deduct another time by entering the time in the function.

for example:
A1: 1:32
A2: 2:42

I can't do =A2-A1-1:02 and get 0:08. If I enter 1:02 in another cell,
then it would work but I'd like to enter the number directly in the
function.

Thanks,
 

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 - Wich Function should I use? 1
VBA Coding Help for Beginner 0
Formatting question: how to format duration (time spent)? 0
Autonumber field in Excel that behaves the same as Access 0
time calculation 5
Subtracting time...again 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Conditional Formatting 2

Top