Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting problem
Hi all,
how must I format a cell which is calculating a time difference in minutes? eg: cell A1: start time: 12:50 cell A2: stop time: 14:50 cell A3: time to deduct [min]: 5 cell A3: time in minutes: =A2-A1-A3 which formula and what format will give me the time in minutes in cell A3? Thanks for any help Regards, Norbert |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting problem
Custom Cell Format
[mm] or [mm]:ss -- Rob van Gelder - http://www.vangelder.co.nz/excel "Orion" wrote in message ... Hi all, how must I format a cell which is calculating a time difference in minutes? eg: cell A1: start time: 12:50 cell A2: stop time: 14:50 cell A3: time to deduct [min]: 5 cell A3: time in minutes: =A2-A1-A3 which formula and what format will give me the time in minutes in cell A3? Thanks for any help Regards, Norbert |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting problem
Thanks Rob, I tried <mm instead of <[mm]
On Thu, 14 Oct 2004 21:16:44 +1300, "Rob van Gelder" wrote: Custom Cell Format [mm] or [mm]:ss "Orion" wrote in message ... Hi all, how must I format a cell which is calculating a time difference in minutes? eg: cell A1: start time: 12:50 cell A2: stop time: 14:50 cell A3: time to deduct [min]: 5 cell A3: time in minutes: =A2-A1-A3 which formula and what format will give me the time in minutes in cell A3? Thanks for any help Regards, Norbert |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formatting problem | Excel Discussion (Misc queries) | |||
formatting problem | Excel Discussion (Misc queries) | |||
csv to xls formatting problem | Excel Discussion (Misc queries) | |||
Formatting problem | Setting up and Configuration of Excel | |||
formatting problem | Excel Discussion (Misc queries) |