Thread: [Solved] Timesheet formula
View Single Post
 
Old 05-27-2011, 06:11 AM
IndCom IndCom is offline Windows XP Office 97
Novice
 
Join Date: May 2011
Posts: 8
IndCom is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
For example, you would type 26/05/2011 10:00PM into one cell and 27/05/2011 8:00AM into the other.
Okay. got 'em formated M/D/Y 00:00PM

Example: 3/9/11 08:00PM

Should I format this with military time (24 hour)- - - or will standard time do the trick? Military time format with date will read M/D/Y 00:00 -

Example 3/9/11 20:00


OK. Lay it on me!


Again......many many thanks for the help here.
Reply With Quote