Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I want to take the difference in two times and figure out how many hours and
minutes there are between them. I already have this working, but my question is how to display it in hours and minutes. This is what I have: F35 - 7:30:00 PM F36 - 11:05:00 PM F37 - =IF(G35F35, (G35-F35)*24, (1+G35-F35)*24) F37 has that formula, but will display 3.58, which means 3 hours and 58/100 of an hour. I would rather this display as hours and minutes. How do I make it do that? If anyone can help, I would appreciate it. Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
time sheet to calculate 2 different columns | Excel Worksheet Functions | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Time and motion chart | Charts and Charting in Excel | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions |