| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Calculation
I have a spreadsheet which is properly doing a time
calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current time. Is there any way I can take another 30 minutes off of this calculation??? Y2-A2-???? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculation
=Y2-A2-30/(24*40)
HTH Kostis Vezerides wnfisba wrote: I have a spreadsheet which is properly doing a time calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current time. Is there any way I can take another 30 minutes off of this calculation??? Y2-A2-???? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculation
=Y5-A2-TIME(0,30,0)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "wnfisba" wrote in message ... I have a spreadsheet which is properly doing a time calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current time. Is there any way I can take another 30 minutes off of this calculation??? Y2-A2-???? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculation
"vezerid" wrote in message
oups.com... wnfisba wrote: I have a spreadsheet which is properly doing a time calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current time. Is there any way I can take another 30 minutes off of this calculation??? Y2-A2-???? =Y2-A2-30/(24*40) HTH Kostis Vezerides But only if you're in a part of the world where there are 40 minutes in an hour. :-) -- David Biddulph |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculation
Bob. How about ... Date and time subtracted from each other to give
aDay,Hour and Minute return? Regards Dan "Bob Phillips" wrote: =Y5-A2-TIME(0,30,0) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "wnfisba" wrote in message ... I have a spreadsheet which is properly doing a time calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current time. Is there any way I can take another 30 minutes off of this calculation??? Y2-A2-???? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Calculation
As long as the difference is less than 32 days you could just subtract one
from the other, and use a format of "d h:mm:ss" (without the quotes) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Michell Major" wrote in message ... Bob. How about ... Date and time subtracted from each other to give aDay,Hour and Minute return? Regards Dan "Bob Phillips" wrote: =Y5-A2-TIME(0,30,0) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "wnfisba" wrote in message ... I have a spreadsheet which is properly doing a time calculation...Y5-A2...from Y5 cell 12:54 and cell A2 which is the current time. Is there any way I can take another 30 minutes off of this calculation??? Y2-A2-???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet Calculation | Excel Discussion (Misc queries) | |||
| #VALUE! in Time Calculation | Excel Worksheet Functions | |||
| perform calculation only if current time is after 10 am | Excel Worksheet Functions | |||
| "Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
| time calculation excel | Excel Worksheet Functions | |||
Linear Mode
