LinkBack URL
About LinkBacks
Try this...
Enter this formula in C2:
=MOD(B2-A2,1)
Format as h:mm
Copy down as needed.
Your average formula is now working. Format that cell as h:mm.
Try this...
Enter this formula in C2:
=MOD(B2-A2,1)
Format as h:mm
Copy down as needed.
Your average formula is now working. Format that cell as h:mm.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks