Formula for computing work time in Excel

Alex Vinokur

Posts: n/a

Formula for computing work time in Excel

Hi,

For instance, A1 = 8:20, B1 = 16:30.
I need to compute in C1 the following: B1 - A1 - 0.5 hour.

What is the formula?

If I use formula B1 - A1 - 0:30 I get invalid value.

Thanks,

--
Alex Vinokur
email: alex DOT vinokur AT gmail DOT com
http://mathforum.org/library/view/10978.html
http://sourceforge.net/users/alexvn

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How can I use a time difference in a subsequent formula in Excel?	numberman37	Excel Worksheet Functions	10	July 26th 05 07:42 PM
Imported Date & Time format with calcs. managed in excel from imrp	Todd F.	Excel Worksheet Functions	0	July 8th 05 09:03 PM
Calculating tvl time in Excel 2000 Rev.9.2720	Brandi	Excel Worksheet Functions	5	January 27th 05 09:15 PM
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't	Damaeus	Excel Worksheet Functions	12	January 23rd 05 04:52 PM
How can i work a formula for time limit?	Roze	Excel Worksheet Functions	2	November 25th 04 02:41 PM

All times are GMT +1. The time now is 05:47 AM.

Menu

About Us