Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Believe me, I've searched Help, but I'm not finding my answer. In A2 I have
a time, formatted as time, which is 8:30 AM. In B7 I have a time, formatted as time, which is 8:00 AM. G7 is formatted h:mm, and I have my formula there, which is =SUM($A$2-B7), which is working properly. It gives me 0:30. Now's the problem. In C7 I have 30 (meaning 30 minutes). In D7, I have 120 (meaning 120 minutes). I don't know how to format C7 and D7 to minutes. I want to also extend the formula in G7 to not only calculate the difference in time between A2 and B7, but to add the minutes in C7 and subtract the minutes in D7. The formula in G7 should give -0:60. Can anyone help? Connie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
Calculating Regular time, overtime and double time | Excel Worksheet Functions | |||
calculating timesheet, time-in/time-out = total hours & minutes, . | Excel Worksheet Functions | |||
Calculating effective time from start/end date+time | Excel Worksheet Functions |