I am constructing a time sheet. I need to be able to do the following, but cannot seem to figure out just how to do it.
January
Date: Sign In Sign out Total Time
7-Jan-14
I would like to be able to format the time and have it displayed in the 24 hour format so that the cell displays time like 08:00 for 8:00 AM or 23:45 for 11:45PM.
Column A would have the date, Column B would display the 24 hour time format and Column C would calculate the difference between the times for pay purposes.
I sure could use your help in figuring out how to format the times to display 24 hour format so that if I enter 800, it will display 08:00 or if I enter 2345 it will display 23:45.
I also could use some help in coming up with the formula that will calculate the total time worked 24 hour day.
Bookmarks