troubles with time

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to extract the number of hours from a time value that is over 24 hours

I want to get 35 out of 35:34:0

This doesn't work: =TEXT(E38,"h") ----> E38 being the cell containing 35:34:0
This doesn't work: =TEXT(E38*24,"h"

35:34:00 is a running total of the amount of time at a task, it doesn't represent a time of day

ALL I WANT IS TO GET IS 35, HOW HARD CAN THAT BE?
 
Hi

=E38-35/24
or
=E38-34/(24*60)
(I didn't unerstand, what exactly want you to do, but I think one of
formulas will do)
 
Back
Top