ExcelBanter - calculating date/time with blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - calculating date/time with blank cells (https://www.excelbanter.com/excel-discussion-misc-queries/155220-calculating-date-time-blank-cells.html)

ferde

calculating date/time with blank cells

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

Teethless mama

calculating date/time with blank cells

=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

ferde

calculating date/time with blank cells

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

All times are GMT +1. The time now is 04:07 PM.