Time Formats using the now() function

Tyler

New Member
Joined
Sep 19, 2006
Messages
5
Hello,

On the system that i am working on i have the current time running to give me accurate measures of ongoing wait times.

For example column A is Start time, Column B is Finish Time and Column C is total time. I have a seperate cell, D2, that holds =now() which i have formatted to show up as h:mm. I am using an IF statement so that if i have not filled in the finish time the total time will show as =$D$2-"start time". This will then produce a time in h:mm format in my total time cell. I am then using conditional formatting to change the row red if the total time is greater than 1hour 15min (1:15). This works fine if the start time and current time are in the AM however if they are in the PM the conditional formatting does not work. I believe this is because the now() produces a number that includes the date.

Does anyone know if there is a way around this>. Is there a funtion similar to now() that will just give the time?

Any help is greatly appreciated
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

Forum statistics

Threads
1,176,434
Messages
5,903,108
Members
435,007
Latest member
tackage

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top