Excel time calculation

J

jc

I want to enter a time in c2 and I want d2 to show a time 50 minutes earlier.
What formula can I use. These time formulas have me baffled.
Note when I format the cell for time and enter 0700 the time returns as 00:00.
 
P

Peo Sjoblom

You shouldn't enter time as 0700 since it means the number 700, enter it in
C2 as 07:00

=C2-time(,50,)


--


Regards,


Peo Sjoblom
 
J

jc

Brilliant. Thanks problem solved

Peo Sjoblom said:
You shouldn't enter time as 0700 since it means the number 700, enter it in
C2 as 07:00

=C2-time(,50,)


--


Regards,


Peo Sjoblom
Click to expand...
 

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

Help with calculating time and a half - I've got straight time and double time. 4
Show a time 50 min before entered time 3
Autonumber field in Excel that behaves the same as Access 0
Formatting question: how to format duration (time spent)? 0
How Can I subtract from time within a 24 hour clock? 3
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
2007 conditional formatting not playing ball 5
Specific hours worked between two time intervals 6

Top