Hi Jim,
Try this:
=A1+15/24/60
or
=A1+15/1440
Regards,
KL
"Jim" wrote in message
...
Hello,
Trying to add 15 minutes to an existing time, for example; A1 has 7:45 PM.
B1 I am wanting show 8:00 by using the formula -A1=15. The result is 7:45
PM. The time is not changing. How do I write this formula?
Thanks
|