| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
[NEWBIE] date/time diff
If A1,B1 are in excel date/time format and C1 in time format
D1 = B1-A1-C and format D1 to Customformat as below for hours and minutes Right clickFormat CellsCustomType: [h]:mm If this post helps click Yes --------------- Jacob Skaria "Jon" wrote: I would like to create the following formulae: A1: Start date/time e.g. Thursday 25/06/2009 08:00 B1: End date/time e.g. Thursday 25/06/2009 18:00 C1: Duration of break e.g. 01:00 (1 hour) D1: B1 - A1 - C1 in hours Any ideas? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
[NEWBIE] date/time diff
I think it was working on Excel 2007 at home, however, at the office where
I'm also using Excel 2007, the value of the formula is being masked with ##########. "Jacob Skaria" wrote: If A1,B1 are in excel date/time format and C1 in time format D1 = B1-A1-C and format D1 to Customformat as below for hours and minutes Right clickFormat CellsCustomType: [h]:mm If this post helps click Yes --------------- Jacob Skaria "Jon" wrote: I would like to create the following formulae: A1: Start date/time e.g. Thursday 25/06/2009 08:00 B1: End date/time e.g. Thursday 25/06/2009 18:00 C1: Duration of break e.g. 01:00 (1 hour) D1: B1 - A1 - C1 in hours Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time diff across DST without VBA? | Excel Discussion (Misc queries) | |||
| date (minus) date = working days diff | Excel Discussion (Misc queries) | |||
| Diff. in time | Excel Worksheet Functions | |||
| Diff. in time | Excel Worksheet Functions | |||
| Diff. in time | Excel Worksheet Functions | |||
Hybrid Mode
