Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes in a column
=TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time.
What can I use to add up the column for a total hrs and minutes? We might run 24 hrs for a whole week. Any help would be appreciated, Fly Boy 5 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes in a column
You can do arithmetic on times, but not text. If you want to do arithmetic, then
don't convert to text. 1. Change your formula to: =b9-a9 2. Format as h:mm 3. Now you can add the column. If the column can total more than 24 hours, use a format of [hh]:mm -- Regards, Fred "Fly Boy 5" wrote in message ... =TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time. What can I use to add up the column for a total hrs and minutes? We might run 24 hrs for a whole week. Any help would be appreciated, Fly Boy 5 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes in a column
Thanks Fred,
It work fine!!!!!!!!! "Fred Smith" wrote: You can do arithmetic on times, but not text. If you want to do arithmetic, then don't convert to text. 1. Change your formula to: =b9-a9 2. Format as h:mm 3. Now you can add the column. If the column can total more than 24 hours, use a format of [hh]:mm -- Regards, Fred "Fly Boy 5" wrote in message ... =TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time. What can I use to add up the column for a total hrs and minutes? We might run 24 hrs for a whole week. Any help would be appreciated, Fly Boy 5 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding hours and minutes in a column
Glad to help. Thanks for the feedback.
-- Regards, Fred "Fly Boy 5" wrote in message ... Thanks Fred, It work fine!!!!!!!!! "Fred Smith" wrote: You can do arithmetic on times, but not text. If you want to do arithmetic, then don't convert to text. 1. Change your formula to: =b9-a9 2. Format as h:mm 3. Now you can add the column. If the column can total more than 24 hours, use a format of [hh]:mm -- Regards, Fred "Fly Boy 5" wrote in message ... =TEXT(B9-A9,"h:mm") This is the formula I'm using to record the down time. What can I use to add up the column for a total hrs and minutes? We might run 24 hrs for a whole week. Any help would be appreciated, Fly Boy 5 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding up hours and minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes | Excel Discussion (Misc queries) | |||
Adding hours and minutes.. | Excel Discussion (Misc queries) | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions | |||
adding hours and minutes | New Users to Excel |