Formula prblem with time

[Pau Rankin]

I have to calculate time in a cell which I have but if no time is entered I want the cell to be blank. ow it reads 0:00s.
Here is what I have.
Cell A1 is time in
Cell A2 is time out
Cell A3 is total time worked.
The formula for the time I have is correct because it has to cover a 24 hour period but what do I add to this to return a blank cell instead of 0s.
=(B1-A1+(B1<A1))*24

[Kaper]

provided what you wrote is right, try:

Please Login or Register  to view this content.

and what is more important: remember to format A3 after correcting formula as General (not time) format.

[martindwilson]

=IF(B1-A1=0,"",(B1-A1+(B1<A1))*24) or slightly shorter

=IF(B1-A1=0,"",MOD(B1-A1,1)*24)

[Kaper]

... or to get rid of 0's not really general, but Custom format:
"General,General,,@"
yes, there are two commas after second general and before @


as usual, even with simple problem a small attached workbook with few pieces of data and desired "manualy calculated" result would make helping easier.

[joeydcaro]

Hi,

Am new to this site which i find really awesome. Am not an expert in excel but i do like playing around with formulas. I have a quick (and hopefully easy) problem which I would want to ask help with:
I am calculating time duration (minutes) and both my Time Start (E7) and Time End (F7) are formatted as "Custom=> 0":"00" so it is easy to type the time (no need to manually press shift and colon). The simple formula for the duration (G7) is F7-E7 which results to 0:00 with the same format of custom=>0":"00. Help?

Thanks!

[martindwilson]

joeydcaro
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[joeydcaro]

My apologies.

As mentioned, I am new here in this site and learning the ropes, so to speak.
Will post my question in a new thread.

Regards,

[joeydcaro]

My apologies.

As mentioned, I am new here in this site and learning the ropes, so to speak.
Will post my question in a new thread.

Regards,