| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding Time
Help please.
I am trying to add times together. Like a clock card. The times are split in hours and mins but the total will add upto more than 24hrs. ex. 9 hrs 34 mins + 13hrs 34 mins + 12 hrs 51 mins. I am not particularly great with spreadsheets so any advice in very basic terms please. Thanks Jackie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding Time
Just add the two cells, but format the result cell (FormatCellsCustom) as
[h]:mm -- HTH Bob Phillips (remove nothere from email address if mailing direct) "suicidal jackie" <suicidal wrote in message ... Help please. I am trying to add times together. Like a clock card. The times are split in hours and mins but the total will add upto more than 24hrs. ex. 9 hrs 34 mins + 13hrs 34 mins + 12 hrs 51 mins. I am not particularly great with spreadsheets so any advice in very basic terms please. Thanks Jackie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| Help with Adding Time Hrs and Mins | Excel Discussion (Misc queries) | |||
| Adding time | New Users to Excel | |||
| adding in time formats | Excel Discussion (Misc queries) | |||
| Adding time to multiple cells using TIMECODE | Excel Discussion (Misc queries) | |||
Linear Mode
