Excel time calculation
 

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.

Excel time calculation
 

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


"jc" wrote in message
...
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.

Excel time calculation
 

Brilliant. Thanks problem solved

"Peo Sjoblom" wrote:

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


"jc" wrote in message
...
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.