| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stupid question -- time calculation
<sigh
I know there is an easy way to do this, I am just too stupid to figure it out... In cell B1 I enter the start time for a meeting (8:20PM) In cell A2 I enter the length of time, in minutes the meeting part is given (10 minutes) In cell B2 I want to see 8:30PM Given every meeting starts at 8:20, what is the formula to enter in B2 that will add A2 and B1??? Go ahead and blast me, I know I must be overlooking something! Mark |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stupid question -- time calculation
look the answer on your other post
"Markndawoods" escreveu: <sigh I know there is an easy way to do this, I am just too stupid to figure it out... In cell B1 I enter the start time for a meeting (8:20PM) In cell A2 I enter the length of time, in minutes the meeting part is given (10 minutes) In cell B2 I want to see 8:30PM Given every meeting starts at 8:20, what is the formula to enter in B2 that will add A2 and B1??? Go ahead and blast me, I know I must be overlooking something! Mark |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stupid question -- time calculation
=b1+timevalue("0:"& A2 &":0") -- mrice Research Scientist with many years of spreadsheet development experience ------------------------------------------------------------------------ mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931 View this thread: http://www.excelforum.com/showthread...hreadid=557930 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stupid question -- time calculation
It's not showing up...
Can you paste into reply here? look the answer on your other post "Markndawoods" escreveu: <sigh I know there is an easy way to do this, I am just too stupid to figure it out... In cell B1 I enter the start time for a meeting (8:20PM) In cell A2 I enter the length of time, in minutes the meeting part is given (10 minutes) In cell B2 I want to see 8:30PM Given every meeting starts at 8:20, what is the formula to enter in B2 that will add A2 and B1??? Go ahead and blast me, I know I must be overlooking something! Mark |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Stupid question -- time calculation
=b1+time(0,a2,0)
hth regareds from Brazil Marcelo "Markndawoods" escreveu: It's not showing up... Can you paste into reply here? look the answer on your other post "Markndawoods" escreveu: <sigh I know there is an easy way to do this, I am just too stupid to figure it out... In cell B1 I enter the start time for a meeting (8:20PM) In cell A2 I enter the length of time, in minutes the meeting part is given (10 minutes) In cell B2 I want to see 8:30PM Given every meeting starts at 8:20, what is the formula to enter in B2 that will add A2 and B1??? Go ahead and blast me, I know I must be overlooking something! Mark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create time calculation formula | Excel Discussion (Misc queries) | |||
| Calculation of Hrs and Mins from 2 Time Frames | Excel Worksheet Functions | |||
| Not as stupid a question; this time about data from multiple sheet | Excel Worksheet Functions | |||
| Time problem, Auto calculation??? | Excel Discussion (Misc queries) | |||
| Best time question | Excel Worksheet Functions | |||
Linear Mode
