Excel time calculation

G

Guest

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
 
G

Guest

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

Show a time 50 min before entered time 3
subtract formula 2
Formula Bar - display of content 4
MS Excel 2007 bug in difference between time 3
Problem with a sumproduct 4
time calculation, 24:00 - 16:00 = 8 3
A challenge in time 6
Formatting time 6

Top