If Formula

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved

5:48 a.m. is in A 1
100 is to be converted to 1:00 using the below formula
6000 =((TRUNC(B1)*60+(B1-TRUNC(B1))*100).to Seconds
1.00 =IF(C1=72000, (C1-72000), C1)/6000 .to Decimal
1:00 a.m. =((TRUNC(D1)*60+(D1-TRUNC(D1))*100)*60)/86400
A B C D E
5:48 a.m. 100 6000 1.00 1:00 a.m.

Question can I put an IF statement in F1 to look at A1
and say if less than 11:59 a.m. then change E1
from a.m. to p.m.

Thanks in advance.
 
Hi
formulas can't change anything in other cells. So no you can't put such
a formula in F1. Also formulas are not able to change formats at all.
sorry to say
 
Thanks for that.
-----Original Message-----
Hi
formulas can't change anything in other cells. So no you can't put such
a formula in F1. Also formulas are not able to change formats at all.
sorry to say

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Back
Top