Working with time calculations


G

Gotroots

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.
 
Ad

Advertisements

J

Jacob Skaria

--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 click>Format
Cells>Custom>

[h]:mm
 
Ad

Advertisements

T

trip_to_tokyo

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top