calculating date/time with blank cells

's Computer Specifications

A B C D
03/31/07 17 40 3/31/07 17:40
04/01/07 14 45 4/1/07 14:45
04/01/07 13 45 4/1/07 13:45
1/0/00 0:00
04/01/07 21 40 4/1/07 21:40
1/0/00 0:00
1/0/00 0:00

Can anyone tell me how I can just get a blank cell in column D when there is
no data to calculate . I'm using this formula:

=A2+B2/24+C2/(24*60)

Thank you in advance for your time
Deb

's Computer Specifications

=IF(A1="","",A1+TIME(B1,C1,0))

Format cells as: m/d/yyyy h:mm

"ferde" wrote:

> A B C D
> 03/31/07 17 40 3/31/07 17:40
> 04/01/07 14 45 4/1/07 14:45
> 04/01/07 13 45 4/1/07 13:45
> 1/0/00 0:00
> 04/01/07 21 40 4/1/07 21:40
> 1/0/00 0:00
> 1/0/00 0:00
>
> Can anyone tell me how I can just get a blank cell in column D when there is
> no data to calculate . I'm using this formula:
>
> =A2+B2/24+C2/(24*60)
>
> Thank you in advance for your time
> Deb
>
>
>

's Computer Specifications

Thank you so much!

"Teethless mama" wrote:

> =IF(A1="","",A1+TIME(B1,C1,0))
>
> Format cells as: m/d/yyyy h:mm
>
>
> "ferde" wrote:
>
> > A B C D
> > 03/31/07 17 40 3/31/07 17:40
> > 04/01/07 14 45 4/1/07 14:45
> > 04/01/07 13 45 4/1/07 13:45
> > 1/0/00 0:00
> > 04/01/07 21 40 4/1/07 21:40
> > 1/0/00 0:00
> > 1/0/00 0:00
> >
> > Can anyone tell me how I can just get a blank cell in column D when there is
> > no data to calculate . I'm using this formula:
> >
> > =A2+B2/24+C2/(24*60)
> >
> > Thank you in advance for your time
> > Deb
> >
> >
> >

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DateDiff Error Calculating Time if Date Closed is Blank	pcover	Microsoft Access	11	26th Oct 2009 07:11 AM
Ignore blank cells when calculating date for If, Then function	AndreaS13	Microsoft Excel Worksheet Functions	2	29th Jul 2008 12:30 AM
Skipping blank cells when calculating time difference	=?Utf-8?B?R0FSRE5FUkdVWQ==?=	Microsoft Excel Misc	3	20th Apr 2007 06:28 PM
Calculating days & time left from start date/time to end date/time	=?Utf-8?B?bWFyaWU=?=	Microsoft Excel Worksheet Functions	7	7th Dec 2005 02:36 PM
I need help calculating blank cells	Glenn V.	Microsoft Excel Worksheet Functions	2	2nd Mar 2004 04:00 AM