Time calculating question

Joined
Feb 7, 2006
Messages
1
Reaction score
0
I have a little problem.
In cell A1=168 (which must be general formated), and means month hours, A2=224:16 (cell is time formated [h]:mm and mean hours and minutes which I worked in job), in A3 I would like to calculate A3:=A2-A1, but I can't get value 56:16.

Any ideas. Thank you?!!

Zoki!
 
Last edited:

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

Counting dates & time. 2
excel formula 1
Converting standard time to decimal time 2
if the numbers in sequence 11
Question 1
Average Question 2
calculating time with IF statement 1
Counting working days. 6

Back
Top