jPaulB
New member
- Joined
- Sep 26, 2013
- Messages
- 7
- Reaction score
- 0
- Points
- 1
- Location
- Moncton, NB, Canada
- Excel Version(s)
- Microsoft Office 2019
Hi Everybody,
I have a job that starts at 4:00PM and runs until about 7:30am the following morning.
I've managed to set the Start Time in say cell B1 and format it for time. It will indicate 4:00PM and the numeric value is: 0.6667
The End Time is in cell B2 and also formatted for time. That will indicate 0.3125
I ought to be able to take and (End Time) - (Start Time) and get a number, -0.3254
The question I have is "How do I express that result -0.3254 in terms of hours?", and "How would I remove a 30 minute break from that result and still display in terms of hours?"
Many thanks,
Paul
I have a job that starts at 4:00PM and runs until about 7:30am the following morning.
I've managed to set the Start Time in say cell B1 and format it for time. It will indicate 4:00PM and the numeric value is: 0.6667
The End Time is in cell B2 and also formatted for time. That will indicate 0.3125
I ought to be able to take and (End Time) - (Start Time) and get a number, -0.3254
The question I have is "How do I express that result -0.3254 in terms of hours?", and "How would I remove a 30 minute break from that result and still display in terms of hours?"
Many thanks,
Paul