Time Formats
How do I format a cell to reflect time as,,,,9am-5pm or 5pm-10pm or 5pm-3am.
I dont want the am/pm to show if possible. I need to make a work schedule but cant figure out how to format time and also add the total hours worked per day for all employees and hour total for week per employee. Any suggestions? |
"Fran" ha scritto nel messaggio
How do I format a cell to reflect time as,,,,9am-5pm or 5pm-10pm or 5pm-3am. I dont want the am/pm to show if possible. I need to make a work schedule but cant figure out how to format time and also add the total hours worked per day for all employees and hour total for week per employee. Any suggestions? You can see at Chip Pearson's site: http://www.cpearson.com/excel/DateTimeEntry.htm and also http://www.cpearson.com/excel/datetime.htm -- Hoping to be helpful... Regards Franz ---------------------------------------------------------------------------------------- To reply translate from italian InVento (no capital letters) ---------------------------------------------------------------------------------------- |
All times are GMT +1. The time now is 08:26 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com