Timesheet formula

IndCom · #1 05-27-2011, 06:11 AM

Quote:

Originally Posted by Colin Legg

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PMT Formula	OneOleGuy	Excel	4	03-05-2011 09:54 AM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM
Timesheet formula help	beardking	Excel	2	11-10-2009 02:06 AM
If formula	sixhobbits	Excel	1	10-02-2009 08:02 AM
Help for formula	dehann	Excel	5	05-01-2009 10:44 AM