G
Greggy
Hey all...
Here's what I am trying to do:
A3 = 4:00am B3 = A3 - 1 I keeping getting #value error in B3 instead
of the result I am hoping to get which is 3:00am.
I have also tried the following in B3:
= A3 - TIME(1,0,0) ---> Again the #value error ...
Even tried = A3 - SUM(01:00)
Can anyone offer a suggestion.
Thanks,
Greg
Here's what I am trying to do:
A3 = 4:00am B3 = A3 - 1 I keeping getting #value error in B3 instead
of the result I am hoping to get which is 3:00am.
I have also tried the following in B3:
= A3 - TIME(1,0,0) ---> Again the #value error ...
Even tried = A3 - SUM(01:00)
Can anyone offer a suggestion.
Thanks,
Greg