formatting time cell
I have a time sheet that calculates time worked. I have the input cells for
the time in, lunch out, etc. They are all formatted Time - 1:30PM. The calculations fail if I enter 8:00AM but if I enter 8:00:00AM the calculations are correct. How do I format the cells so that I don't have to enter the seconds? oldjay |
formatting time cell
from the top of the head should there not be a spca betwen time and am or pm even if you type 5:00 a it will be eneterd as 5:00 AM and the formula bar will show 5:00:00 AM if you dont give space it will be taken as text. i hope I am correct. "Oldjay" wrote: I have a time sheet that calculates time worked. I have the input cells for the time in, lunch out, etc. They are all formatted Time - 1:30PM. The calculations fail if I enter 8:00AM but if I enter 8:00:00AM the calculations are correct. How do I format the cells so that I don't have to enter the seconds? oldjay |
formatting time cell
Thanks I wasn't putting in the space
"venkat" wrote: from the top of the head should there not be a spca betwen time and am or pm even if you type 5:00 a it will be eneterd as 5:00 AM and the formula bar will show 5:00:00 AM if you dont give space it will be taken as text. i hope I am correct. "Oldjay" wrote: I have a time sheet that calculates time worked. I have the input cells for the time in, lunch out, etc. They are all formatted Time - 1:30PM. The calculations fail if I enter 8:00AM but if I enter 8:00:00AM the calculations are correct. How do I format the cells so that I don't have to enter the seconds? oldjay |
formatting time cell
When entering time, I type simply the 8 and the colon and press enter, and
it's in there as 8am. I do have to enter afternoon times militarily though, as in 13 colon 30 for 1:30pm, but it saves a lot of entry time. "Oldjay" wrote... The calculations fail if I enter 8:00AM but if I enter 8:00:00AM the calculations are correct. How do I format the cells so that I don't have to enter the seconds? << |
All times are GMT +1. The time now is 11:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com