You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: TenpinBozz
TenpinBozz Author
User level: Level 1
9 points

Time Formula follow on question

My original Question

I would like a formula to caculate the number of hours between 2 times. With a start time before midnight and an end time after midnight .ie:If cell B2 is start time & cell C2 is an end time next day I want cell D2 to give me total hours in digital format. I am using Numbers 12.Any ideas please

Answered (formula shown below)


My follow on Question

The formula below does what I want it to do,However when creating a spreadsheet for a month cells in column D which do not yet have result to show display a red triangle with an exclamation mark. Is it possible to create the formula for the cell in column D to remain blank until there is an answer to display.

Formula in D2 (and fill down):

DUR2HOURS(IF(C2<B2,C2−B2+"1d",C2−B2))

iMac 27″, macOS 11.6

Posted on Apr 9, 2022 1:14 AM

Reply
Question marked as Top-ranking reply
User profile for user: Yellowbox
Yellowbox
User level: Level 7
21,209 points

Posted on Apr 9, 2022 5:44 AM

Hello again TenpinBozz,


Try this:



Formula in D2 (and fill down):

IF(C2="","",DUR2HOURS(IF(C2<B2,C2−B2+"1d",C2−B2)))


If a cell in Column C is blank ("") then insert blank ("") in that row in Column D.

Else, Numbers will run the formula: DUR2HOURS(IF(C2<B2,C2−B2+"1d",C2−B2))


Regards,

Ian.


View in context

Similar questions

2 replies

Time Formula follow on question

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up