Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=B1-A1-TIME(0,30,0)
-- HTH Bob Phillips "Alex Vinokur" wrote in message ... 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 |
#3
|
|||
|
|||
"Bob Phillips" wrote in message ... =B1-A1-TIME(0,30,0) Thanks, Bob! It works fine. [snip] -- Alex Vinokur email: alex DOT vinokur AT gmail DOT com http://mathforum.org/library/view/10978.html http://sourceforge.net/users/alexvn |
#4
|
|||
|
|||
That's because time is really just a floating point number.
1 is 1 day and hour is 1/24 a half hour is 1/48 =B1 - A1 - 1/48 will work just fine -- Gary''s Student "Alex Vinokur" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I use a time difference in a subsequent formula in Excel? | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Calculating tvl time in Excel 2000 Rev.9.2720 | Excel Worksheet Functions | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
How can i work a formula for time limit? | Excel Worksheet Functions |