Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duration in Hours (or hh:mm:ss)
Hi All,
I'm currently trying to create a column in a sheet which calculates the age in hours (or hours and minutes, though hours is optimal) that have elapsed since the date/time stamp in the column which proceeds it. Is there any way to manage this outside of a VBA solution? I'm about as green as it gets when it comes to VBA, and I'm sort of surprised to find that there isn't a standard function (like datedif) which supports this. Any help would be greatly appreciated. Thanks Jamie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duration in Hours (or hh:mm:ss)
=now()-prior cell
Format cell as time Will change any time you type into the spreadsheet. "MJW" wrote: Hi All, I'm currently trying to create a column in a sheet which calculates the age in hours (or hours and minutes, though hours is optimal) that have elapsed since the date/time stamp in the column which proceeds it. Is there any way to manage this outside of a VBA solution? I'm about as green as it gets when it comes to VBA, and I'm sort of surprised to find that there isn't a standard function (like datedif) which supports this. Any help would be greatly appreciated. Thanks Jamie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duration in Hours (or hh:mm:ss)
Thanks Sean--I considered using "NOW()", but was hung up on the dynamic
nature you mentioned. Of course I just realized moments ago that I'll be saved as long as I only update it when the data's needed--once I make a pivot of the data and port that over to the master workbook, it'll be a static value. Much appreciated! --Jamie "Sean Timmons" wrote: =now()-prior cell Format cell as time Will change any time you type into the spreadsheet. "MJW" wrote: Hi All, I'm currently trying to create a column in a sheet which calculates the age in hours (or hours and minutes, though hours is optimal) that have elapsed since the date/time stamp in the column which proceeds it. Is there any way to manage this outside of a VBA solution? I'm about as green as it gets when it comes to VBA, and I'm sort of surprised to find that there isn't a standard function (like datedif) which supports this. Any help would be greatly appreciated. Thanks Jamie |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duration in Hours (or hh:mm:ss)
=NOW()-A1 and format the cell appropriately, such as [h]:mm
If you want it converting to decimal hours, use =24*(NOW()-A1) and format as General or number. -- David Biddulph "MJW" wrote in message ... Hi All, I'm currently trying to create a column in a sheet which calculates the age in hours (or hours and minutes, though hours is optimal) that have elapsed since the date/time stamp in the column which proceeds it. Is there any way to manage this outside of a VBA solution? I'm about as green as it gets when it comes to VBA, and I'm sort of surprised to find that there isn't a standard function (like datedif) which supports this. Any help would be greatly appreciated. Thanks Jamie |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duration in Hours (or hh:mm:ss)
If you don't want to use NOW(), you can put current time into a cell with
control-shift-colon, or current date with control-semi-colon, or both together with control-semi-colon space control-shift-colon. -- David Biddulph "MJW" wrote in message ... Thanks Sean--I considered using "NOW()", but was hung up on the dynamic nature you mentioned. Of course I just realized moments ago that I'll be saved as long as I only update it when the data's needed--once I make a pivot of the data and port that over to the master workbook, it'll be a static value. "Sean Timmons" wrote: =now()-prior cell Format cell as time Will change any time you type into the spreadsheet. "MJW" wrote: Hi All, I'm currently trying to create a column in a sheet which calculates the age in hours (or hours and minutes, though hours is optimal) that have elapsed since the date/time stamp in the column which proceeds it. Is there any way to manage this outside of a VBA solution? I'm about as green as it gets when it comes to VBA, and I'm sort of surprised to find that there isn't a standard function (like datedif) which supports this. Any help would be greatly appreciated. Thanks Jamie |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duration in Hours (or hh:mm:ss)
Note that using Ctrl + colon will truncate the seconds, so even if the
computer's clock is 09:23:58 it will come out as 09:23:00. -- Regards, Peo Sjoblom "David Biddulph" <groups [at] biddulph.org.uk wrote in message ... If you don't want to use NOW(), you can put current time into a cell with control-shift-colon, or current date with control-semi-colon, or both together with control-semi-colon space control-shift-colon. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel calculation of duration in hours and minutes | Excel Worksheet Functions | |||
Enter Hours duration over 24 | New Users to Excel | |||
fx duration | Excel Worksheet Functions | |||
Duration | Excel Discussion (Misc queries) | |||
Duration | Excel Discussion (Misc queries) |