| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Use custom [mm] formated value that is displayed in a calculation
How can the custom [mm] formated value that is displayed in a cell be used in
a calculation when it is the result of the difference between two dates entered as d/mm/yy h:mm |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use custom [mm] formated value that is displayed in a calculation
If your date/times are in A1 and A2, then in A3 enter:
=(A2-A1)*24*60 -- Gary''s Student - gsnu200857 "WJPS" wrote: How can the custom [mm] formated value that is displayed in a cell be used in a calculation when it is the result of the difference between two dates entered as d/mm/yy h:mm |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use custom [mm] formated value that is displayed in a calculation
Certainly it can. The only problem will be if you have more than 1000
minutes, you can't get Excel to insert commas. Regards, Fred. "WJPS" wrote in message ... How can the custom [mm] formated value that is displayed in a cell be used in a calculation when it is the result of the difference between two dates entered as d/mm/yy h:mm |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use custom [mm] formated value that is displayed in a calculat
Thankyou; that works.
"Gary''s Student" wrote: If your date/times are in A1 and A2, then in A3 enter: =(A2-A1)*24*60 -- Gary''s Student - gsnu200857 "WJPS" wrote: How can the custom [mm] formated value that is displayed in a cell be used in a calculation when it is the result of the difference between two dates entered as d/mm/yy h:mm |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Use custom [mm] formated value that is displayed in a calculat
Glad I could help. Thanks for the feedback.
Regards, Fred "WJPS" wrote in message ... Thankyou; that works. "Gary''s Student" wrote: If your date/times are in A1 and A2, then in A3 enter: =(A2-A1)*24*60 -- Gary''s Student - gsnu200857 "WJPS" wrote: How can the custom [mm] formated value that is displayed in a cell be used in a calculation when it is the result of the difference between two dates entered as d/mm/yy h:mm |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Calculation in a Pivot Table | Excel Discussion (Misc queries) | |||
| custom percentage calculation | Excel Discussion (Misc queries) | |||
| % of subtotal custom calculation in a pivot table | Excel Discussion (Misc queries) | |||
| Pivot table - Custom calculation question | Excel Worksheet Functions | |||
| use displayed value in calculation | New Users to Excel | |||
Linear Mode
