Working with time calculations
 

When working with time calculations I am finding it difficuult to subtract a
specified time.

Example:

In: 8:46:00 AM C5

Out: 5:17:00 PM D5

Break: :45 min F5

Total: 8:31 =(D5-C5)-F5

The formula I used above returns an #VALUE! error

Thank you if you can help.

Working with time calculations
 

Hi

You have to enter the break as a true time in F5;

0:45

Regards,
Per

"Gotroots" skrev i meddelelsen
...
When working with time calculations I am finding it difficuult to subtract
a
specified time.

Example:

In: 8:46:00 AM C5

Out: 5:17:00 PM D5

Break: :45 min F5

Total: 8:31 =(D5-C5)-F5

The formula I used above returns an #VALUE! error

Thank you if you can help.

Working with time calculations
 

--Make sure the format of data in cells C5 and D5 are in excel time format.
To enter current time use Ctrl+Shift+semicolon and then edit the time to suit

--In F5 enter time as 00:45 instead of :45

--Apply the formula and custom format the cell as below. Right clickFormat
CellsCustom

[h]:mm

--
Jacob


"Gotroots" wrote:

When working with time calculations I am finding it difficuult to subtract a
specified time.

Example:

In: 8:46:00 AM C5

Out: 5:17:00 PM D5

Break: :45 min F5

Total: 8:31 =(D5-C5)-F5

The formula I used above returns an #VALUE! error

Thank you if you can help.

Working with time calculations
 

I have just put a file up for you at:-

http://www.pierrefondes.com/

Item number 29 towards the top of the page (at the top at the moment) where
you can see your example working successfully.

Please hit Yes if my comments have helped.

Thanks.


"Gotroots" wrote:

When working with time calculations I am finding it difficuult to subtract a
specified time.

Example:

In: 8:46:00 AM C5

Out: 5:17:00 PM D5

Break: :45 min F5

Total: 8:31 =(D5-C5)-F5

The formula I used above returns an #VALUE! error

Thank you if you can help.