Excel help.
21 May 2013, 05:58 PM
#1
Scooby Regular
Thread Starter
Join Date: Nov 2004
Location: In a 405 BHP/360 ft/lb P1 with SN superstar Sonic dog at my side!
Posts: 1,959
Likes: 0
Received 0 Likes
on
0 Posts
Excel help.
I have what I think should be simple but can't seem to sort it out. I want to do a calculation involving start and end times that cross midnight.
If someone could solve this then it will give me the bigger picture. Any help much appreciated.
Example:
Cell A1 is formatted as a time (hh:mm) in it is 22:45. This is a start time.
Cell A2 is formatted the same, in it is 01:15. This is an end time
Obviously the total time is 2 hours 30 mins. I want to express this as as a decimal in a general or number formatted cell (2.5).
Basically I want 01:15-22:45 to equal 2.5
How do I do it.?
If someone could solve this then it will give me the bigger picture. Any help much appreciated.
Example:
Cell A1 is formatted as a time (hh:mm) in it is 22:45. This is a start time.
Cell A2 is formatted the same, in it is 01:15. This is an end time
Obviously the total time is 2 hours 30 mins. I want to express this as as a decimal in a general or number formatted cell (2.5).
Basically I want 01:15-22:45 to equal 2.5
How do I do it.?
Thread
Thread Starter
Forum
Replies
Last Post
Mattybr5@MB Developments
Full Cars Breaking For Spares
28
28 December 2015 11:07 PM
Mattybr5@MB Developments
Full Cars Breaking For Spares
12
18 November 2015 07:03 AM
