=NOW() causes different results than manually coded time in duration calculation

excelmayday

New Member
Joined
Oct 18, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
I want to track the number of hours tasks take in order to show both the time an ongoing task has take so far as well as how long a completed task took. I hoped to use the current date and time functions,=TODAY() & =NOW(), in the Completed Day and Time" cells for tasks that have not completed yet to track number of hours so far and then manually enter date and time in these cells when the task completed.

However, though the =TODAY() function words fine, as explained below I can't figure out how to get the =NOW() function to provide the same results as when I enter the Completion Time manually .

1603034765220.png


Lines A & B are identical except that the End Time in A is entered manually while the End Time in B uses the current time function, =NOW().

The Hours Duration cells are identical, except for cell references, to subtract End Date + End Time from Current Date + Current Time and then multiply by 24: =((F45+G45)-(D45+E45))*24

The formats of the Hours Duration cell are identical (number with 2 decimal places).

I want the Hours Duration value to like like Line A's but so far have not figured out a way to do it using =NOW(). Can anyone help?
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
53,236
Office Version
  1. 365
Platform
  1. Windows
Hi & welcome to MrExcel.
The reason you get that number is that NOW includes the date, try
Excel Formula:
=(G45-(D45+E45))*24
 

Watch MrExcel Video

Forum statistics

Threads
1,123,194
Messages
5,600,262
Members
414,374
Latest member
akbir

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